View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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