Data Validate not working on a sheet
 

I have a range that I have done a Data / Validate to a list but the arrown to
do the drop down does not pop up when you select the cell. I have done the
validate on another sheet and it works fine. Is there a control on a
worksheet to not show that?

thanks in advance...

Data Validate not working on a sheet
 

Browse through Debra's common reasons.

http://www.contextures.on.ca/xlDataV...rowsNotVisible


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 14:31:03 -0700, Don wrote:

I have a range that I have done a Data / Validate to a list but the arrown to
do the drop down does not pop up when you select the cell. I have done the
validate on another sheet and it works fine. Is there a control on a
worksheet to not show that?

thanks in advance...

Data Validate not working on a sheet
 

Thanks, that realy helped. Turned out I had to repair the file as it was
somehow corrupted but not enough to tell me. How rude.

thanks

"Gord Dibben" wrote:

Browse through Debra's common reasons.

http://www.contextures.on.ca/xlDataV...rowsNotVisible


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 14:31:03 -0700, Don wrote:

I have a range that I have done a Data / Validate to a list but the arrown to
do the drop down does not pop up when you select the cell. I have done the
validate on another sheet and it works fine. Is there a control on a
worksheet to not show that?

thanks in advance...