It's the only way IF somebody has used VBA to make the sheet xlsheetveryhidden


"Kevin B" wrote:

I wouldn't have thought of that, although I've done it in the past. Thanks
for the heads up...
--
Kevin Backmann


"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.