how do i find where a drop down list is hidden so it can be edited

Hi Vgee,

Try:

Activesheet.Shapes("Drop Down 1").Visible=True


Change the name of the control to accord with your situation.


---
Regards,
Norman



"vgee" <vgee@discussions.microsoft.com> wrote in message
news:DB52C05A-4478-40B7-892A-15B1E5B47E4F@microsoft.com...
>

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