Can't view formulas referenced tab


G

Guest

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

Advertisements

G

Guest

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
 
G

Guest

Click WINDOw in the menu and see if there's a worksheet to unhide. If that
is one of the obvious things you've already tried please excuse...
 
G

Guest

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

Guest

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
 
Ad

Advertisements

G

Guest

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?
 
Ad

Advertisements

G

Guest

I got it to work - for some reason it wouldn't let me - then I closed the
file and reopened it and it let me - thanks for all your help!!!!!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top