Hi Vgee,
Try:
Activesheet.Shapes("Drop Down 1").Visible=True
Change the name of the control to accord with your situation.
---
Regards,
Norman
"vgee" <[email protected]> wrote in message
news:[email protected]...
>
And if the dropdown list is the result of Data|Validation
select a single cell (or a range of cells to search)
Edit|goto|special
check the Data Validation option
(and use All)
Then for each of those cells:
data|validation
see if there's a list in that dialog or if it points at another range.
vgee wrote:
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks