Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide tabs
Excel/VB Gurus,
I have a spreadheet with multiple tabs. On the main tab ("Master Invoice"), column Q has a formula that enters a "Y" or an "N" based on a date field in cell C10. I want to hide all the tabs that correspond to the "Y" in column Q on "Master Invoice". Cell C10 is formatted to match the tab names (these tab names are the end date of specific periods - ie July 9, July 16, etc.). So, if C10 is July 16, I only want to see 2 tabs - "Master Invoice" and "July 16". If C10 is July 30, I only want to see "Master Invoice" and July 30" tabs. Is this possible? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide tabs
Yes its easy. Drag tabs not to be seen to the right of the tab bar and
shorten the tab bar by dragging the divider at the end to the left to show only what you require. Skinman. "brentm" wrote in message ... Excel/VB Gurus, I have a spreadheet with multiple tabs. On the main tab ("Master Invoice"), column Q has a formula that enters a "Y" or an "N" based on a date field in cell C10. I want to hide all the tabs that correspond to the "Y" in column Q on "Master Invoice". Cell C10 is formatted to match the tab names (these tab names are the end date of specific periods - ie July 9, July 16, etc.). So, if C10 is July 16, I only want to see 2 tabs - "Master Invoice" and "July 16". If C10 is July 30, I only want to see "Master Invoice" and July 30" tabs. Is this possible? Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide tabs
I have probably misconstrued what you require after reading it a second time
if so, sorry "brentm" wrote in message ... Excel/VB Gurus, I have a spreadheet with multiple tabs. On the main tab ("Master Invoice"), column Q has a formula that enters a "Y" or an "N" based on a date field in cell C10. I want to hide all the tabs that correspond to the "Y" in column Q on "Master Invoice". Cell C10 is formatted to match the tab names (these tab names are the end date of specific periods - ie July 9, July 16, etc.). So, if C10 is July 16, I only want to see 2 tabs - "Master Invoice" and "July 16". If C10 is July 30, I only want to see "Master Invoice" and July 30" tabs. Is this possible? Thanks in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide tabs
What I want to accomplish is a) I want the invoice tab to always remain unhid
and b) I want the tab that is named the same date as the invoice is being generated for to also be unhid and c) I want all other tabs hidden. So here is an example of what I have: tab 1 = "Invoice" tab 2 = "July 2" tab 3 = "July 9" tab 4 = "July 16" If I am generating an invoice for July 2, I want tabs "July 9" and "July 16" hidden. If I am generating an invoice for July 16, I want tabs "July 2" and "July 9" hidden. I hope this helps clarify my question. Thanks again. "Skinman" wrote: I have probably misconstrued what you require after reading it a second time if so, sorry "brentm" wrote in message ... Excel/VB Gurus, I have a spreadheet with multiple tabs. On the main tab ("Master Invoice"), column Q has a formula that enters a "Y" or an "N" based on a date field in cell C10. I want to hide all the tabs that correspond to the "Y" in column Q on "Master Invoice". Cell C10 is formatted to match the tab names (these tab names are the end date of specific periods - ie July 9, July 16, etc.). So, if C10 is July 16, I only want to see 2 tabs - "Master Invoice" and "July 16". If C10 is July 30, I only want to see "Master Invoice" and July 30" tabs. Is this possible? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide-unhide | Excel Programming | |||
hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
Hide / Unhide Sheet Tabs Excel 2007 | Excel Discussion (Misc queries) | |||
How to unhide worksheet tabs in Excel 2007? | Excel Discussion (Misc queries) | |||
How to hide/unhide sheet Tabs in Excel 2007? | Excel Worksheet Functions |