Greetings

Not sure what I did, but the drop down list that I created for data
validation is no longer showing. However, still I can only type valid
data that is in the list. So the validation part is working, but
there is no drop down menu for each applicable cell.

I did freeze pane, but removed it. I also read that you have to make
all objects visible. How do you do this in 2007??

Any other suggestions?

In Data Validation, you get an option to show the available list in
dropdown or not, you need to re-enable that.

Cosmo Kramer;494186 Wrote:
Greetings

Not sure what I did, but the drop down list that I created for data
validation is no longer showing. However, still I can only type valid
data that is in the list. So the validation part is working, but
there is no drop down menu for each applicable cell.

I did freeze pane, but removed it. I also read that you have to make
all objects visible. How do you do this in 2007??

Any other suggestions?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=136150