Hey Duke,

Thanks, but that didn't work because in VBA I it shows it exists - but won't
allow me to view it.

In VBA - under the XLS file properties. It shows that this file has 6
Sheets, the first one is visible - the other 5 are "hidden" - when I try to
them "visible" I get an error message that says "Unable to set the Visible
property of the Worksheet class"

Any ideas????

Paul

"Duke Carey" wrote:

press Alt-F11 to open the VBA editor (VBE)
press Ctrl-G to open the Immediate window at the bottom right of the screen
Paste in

thisworkbook.Sheets("Items").visible = xlsheetvisible

and press enter

Alt-tab back to Excel



"pablobandito" wrote:

I have a file that references another tab. I have done all the obvious
things to be able to see other tabs; to no success.

The formula is "=LOOKUP(Q4,Items!$A$3:$A$50,Items!$B$3:$B$50) "

I know the tab is contained within this worksheet because the cell changes
if I change the reference in the formula.

I do not see the "Items" tab but I really need too. Does anyone have any
suggestions.