hide/unhide tabs

B

brentm

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

Skinman

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

Skinman

I have probably misconstrued what you require after reading it a second time
if so, sorry
 
B

brentm

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top