Did you try the code?

If that doesn't do it, you'll have to get somebody more knowledgeable than
me to guide you.

By the way, what do you mean "under the XLS file properties" Do you mean
you see the tree in the upper left corner with the bolded
VBAProject(filename) and all the worksheets below it?


"pablobandito" wrote:

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.