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.

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

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

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

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

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

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

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