Drop Down Arrow for Cell Validation disappeared

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.

Re: Drop Down Arrow for Cell Validation disappeared

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" 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.
|
|

Re: Drop Down Arrow for Cell Validation disappeared

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" 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.
> |
> |
>
>
>