software

I created a worksheet that contained cells with drop-downs created via
data/validation using a named list. The list resides on another sheet in the
same workbook.The users did something to make the drop downs disappear and
now I cannot reestablish them. I have done this numerous times and cannot
figure out why I cannot do it now. I checked to assure I have the required
Add-ins, so that's not the problem. Can there be a setting somewhere that is
preventing it? Help!

You could try:

lt;Toolsgt; lt;Optionsgt; lt;Viewgt; tab,

And make sure that under quot;Objectsquot;,

quot;Hide Allquot; is *UNCHECKED*.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===quot;Jan Buckleyquot; gt; wrote in message
...
I created a worksheet that contained cells with drop-downs created via
data/validation using a named list. The list resides on another sheet in the
same workbook.The users did something to make the drop downs disappear and
now I cannot reestablish them. I have done this numerous times and cannot
figure out why I cannot do it now. I checked to assure I have the required
Add-ins, so that's not the problem. Can there be a setting somewhere that is
preventing it? Help!
Thanks for the response, but I think the entire sheet has been corrupted. I
copied it to another sheet in the same workbook and then had no problems
establishiing the validation lists. Thanks again.

quot;RagDyeRquot; wrote:

gt; You could try:
gt;
gt; lt;Toolsgt; lt;Optionsgt; lt;Viewgt; tab,
gt;
gt; And make sure that under quot;Objectsquot;,
gt;
gt; quot;Hide Allquot; is *UNCHECKED*.
gt;
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt;
gt; quot;Jan Buckleyquot; gt; wrote in message
gt; ...
gt; I created a worksheet that contained cells with drop-downs created via
gt; data/validation using a named list. The list resides on another sheet in the
gt; same workbook.The users did something to make the drop downs disappear and
gt; now I cannot reestablish them. I have done this numerous times and cannot
gt; figure out why I cannot do it now. I checked to assure I have the required
gt; Add-ins, so that's not the problem. Can there be a setting somewhere that is
gt; preventing it? Help!
gt;
gt;
gt;