Can't view formulas referenced tab
 

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.

Can't view formulas referenced tab
 

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.

Can't view formulas referenced tab
 

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...
--
Kevin Backmann


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

Can't view formulas referenced tab
 

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.

Can't view formulas referenced tab
 

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.

Can't view formulas referenced tab
 

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.

Can't view formulas referenced tab
 

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.

Can't view formulas referenced tab
 

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!!!!!!!!!

"Duke Carey" wrote:

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.