Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I view color onscreen (it shows up in print view only) | Excel Discussion (Misc queries) | |||
column is hidden in normal view but not print view | Excel Worksheet Functions | |||
How can I view color coordinated formulas | Excel Worksheet Functions | |||
view worksheet formulas | Excel Discussion (Misc queries) | |||
How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) |