Drop Down Box Disappeared
 

I have special copied my spreadsheet and in the past this as worked but now
my spreadsheets' drop down box has disappeared on line 6453 but is on line
6452? How can I get it to continue?

Drop Down Box Disappeared
 

When you say drop down, do you mean validation?

If so, you can set the validation from the data menu bar.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=542644

Drop Down Box Disappeared
 

Hello, I am not sure, but when I went to the data menu the validation choice
was not an option. Can you help with another suggestion? It is strange the
box is on the line above but not the next line. Any suggestions you may have
would be greatly appreciated.
Thank you for responding.
Shari

"mrice" wrote:


When you say drop down, do you mean validation?

If so, you can set the validation from the data menu bar.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=542644

Drop Down Box Disappeared
 

Sounds like your worksheet might be protected?


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=542644