Drop Down List not Appearing
 

I'm having a problem in a worksheet where a cell that has Data Validation
using a Drop down list is not appearing. The check box is ticked beside 'in
cell drop down'. I am using Excel97 and the Worksheet is protected. The cell
where the Drop down should be is not locked so I'm a bit lost

Any ideas?

Thanks

Are objects visible?

To make them visible, choose ToolsOptions
On the View tab, for Objects, select Show All, or Show Placeholders


John wrote:
I'm having a problem in a worksheet where a cell that has Data Validation
using a Drop down list is not appearing. The check box is ticked beside 'in
cell drop down'. I am using Excel97 and the Worksheet is protected. The cell
where the Drop down should be is not locked so I'm a bit lost


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Excel 97 also had a problem showing DV drop-down arrows when WindowFreeze
Panes was enabled.

Anything above the "freeze line" would be hidden.

Gord Dibben Excel MVP

On Wed, 03 Nov 2004 16:30:45 -0500, Debra Dalgleish
wrote:

Are objects visible?

To make them visible, choose ToolsOptions
On the View tab, for Objects, select Show All, or Show Placeholders


John wrote:
I'm having a problem in a worksheet where a cell that has Data Validation
using a Drop down list is not appearing. The check box is ticked beside 'in
cell drop down'. I am using Excel97 and the Worksheet is protected. The cell
where the Drop down should be is not locked so I'm a bit lost

Thanks Gird, that seems to be the reason


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Excel 97 also had a problem showing DV drop-down arrows when WindowFreeze
Panes was enabled.

Anything above the "freeze line" would be hidden.

Gord Dibben Excel MVP

On Wed, 03 Nov 2004 16:30:45 -0500, Debra Dalgleish

wrote:

Are objects visible?

To make them visible, choose ToolsOptions
On the View tab, for Objects, select Show All, or Show Placeholders


John wrote:
I'm having a problem in a worksheet where a cell that has Data
Validation
using a Drop down list is not appearing. The check box is ticked beside
'in
cell drop down'. I am using Excel97 and the Worksheet is protected. The
cell
where the Drop down should be is not locked so I'm a bit lost