Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF

Links

XODOX
Impressum

#1: Drop Down Arrow for Cell Validation disappeared

Posted on 2008-04-22 09:53:00 by Baggins

Hello,

I use a spreadsheet as a calendar with a separate sheet for each month. I
have the days going across the top and a list of staff names down the side.

In the middle of each sheet are drop down menus (using cell validation)
where the staff can select if they are "In" or "Out" (plus a load of other
options).

This works fine on every month except one where there is no drop down arrow
when you click in the cell.

I have check the cell validation and it says the same as all the others and
am pulling my hair out!!

Is there a sheet option somewhere that I may have missed that restricts cell
validation or anything else that prevents this from showing?

Many thanks.

Report this message

#2: Re: Drop Down Arrow for Cell Validation disappeared

Posted on 2008-04-22 10:49:42 by Stefan B Rusynko

This is a FrontPage newsgroup
- suggest you ask in an Excel newsgroup

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


"Baggins" <Baggins@discussions.microsoft.com> wrote in message news:8AA79F54-D1F1-4800-8327-017494D440B0@microsoft.com...
| Hello,
|
| I use a spreadsheet as a calendar with a separate sheet for each month. I
| have the days going across the top and a list of staff names down the side.
|
| In the middle of each sheet are drop down menus (using cell validation)
| where the staff can select if they are "In" or "Out" (plus a load of other
| options).
|
| This works fine on every month except one where there is no drop down arrow
| when you click in the cell.
|
| I have check the cell validation and it says the same as all the others and
| am pulling my hair out!!
|
| Is there a sheet option somewhere that I may have missed that restricts cell
| validation or anything else that prevents this from showing?
|
| Many thanks.
|
|

Report this message

#3: Re: Drop Down Arrow for Cell Validation disappeared

Posted on 2008-04-22 11:46:01 by Baggins

Apologies - I'm having a lot of problems with my drop downs this morning -
must have selected wrong newsgroup!


"Stefan B Rusynko" wrote:

> This is a FrontPage newsgroup
> - suggest you ask in an Excel newsgroup
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "Baggins" <Baggins@discussions.microsoft.com> wrote in message news:8AA79F54-D1F1-4800-8327-017494D440B0@microsoft.com...
> | Hello,
> |
> | I use a spreadsheet as a calendar with a separate sheet for each month. I
> | have the days going across the top and a list of staff names down the side.
> |
> | In the middle of each sheet are drop down menus (using cell validation)
> | where the staff can select if they are "In" or "Out" (plus a load of other
> | options).
> |
> | This works fine on every month except one where there is no drop down arrow
> | when you click in the cell.
> |
> | I have check the cell validation and it says the same as all the others and
> | am pulling my hair out!!
> |
> | Is there a sheet option somewhere that I may have missed that restricts cell
> | validation or anything else that prevents this from showing?
> |
> | Many thanks.
> |
> |
>
>
>

Report this message