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.

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.

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.

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.