Can't find a drop down menu source

[stacilyne]

So I'm working with a spreadsheet I didn't create, but I need to add information to a drop down list. I went to Data->Data Validation and this is what it's telling me is the source..
=F9_Hidden_Lists!$A$2:$A$20

Thing is...I don't know where this "F9_Hidden_Lists" is at. I have made sure to unhide every worksheet, tried doing a find in the entire workbook, tried looked under Formula->Name Manager, and even looked on every tab in cell A2 thinking maybe I would magically see the list somewhere!

I'm completely stumped.

 

[SQUIDD]

hello

have you checked to see if the sheet properties have been set to VERY HIDDEN?

Dave

 

[SQUIDD]

go into the VB editor

press alt and f11

click on view, the properties window, then view the sheet properties.

my guess is you will find the sheet in the project explorer window

 

[stacilyne]

You are awesome! That was it. I've been going nuts for hours. THANK YOU SO MUCH!

 

[SQUIDD]

you are very welcome.

glad to have helped.

thankyou for the feedback

dave

 

[BHG]

go into the VB editor

press alt and f11

click on view, the properties window, then view the sheet properties.

my guess is you will find the sheet in the project explorer window

Thanks, that'a worked!