Hiding Tabs

[newguy]

I am trying to find a way to hide or show tabs based answers from a
user on a menu page. So if the user answers "yes" to the first
question then tab 1 shows up if "no" tab 1 does not show up. Haven't
had a lot of experience with VBA thank you for your help.

 

[Wullie]

what do you mean by tabs? do you mean the worksheet tabs at the bottom?

 

[newguy]

what do you mean by tabs? do you mean the worksheet tabs at the bottom?

Yes

 

[Rick Rothstein]

You can't hide the tabs individually... either they all are visible or they
all are not visible. To hide all the tabs, execute this statement...

ActiveWindow.DisplayWorkbookTabs = False

to redisplay them again, execute this statement...

ActiveWindow.DisplayWorkbookTabs = True

--
Rick (MVP - Excel)

what do you mean by tabs? do you mean the worksheet tabs at the bottom?

Yes

 

[newguy]

If I can't hide tabs individually can I add tabs individually based on
a template? My original plan was to have a 10 or so tabs and 10
questions based on their answers (Yes/No) they would either show up or
be hidden. Can I instead have the worksheets saved as templates and
based on their answers to the questions add those templates as tabs?

 

[Rick Rothstein]

Based on the wording of your latest post, I think I need a clarification
please. Perhaps you and I are using the word "tabs" differently... the tabs
I was talking about in my response is the small extension located at the
bottom of a worksheet that contains the name of the worksheet... your last
response makes me think you might be talking about the entire worksheet.
Exactly what do you want to be hidden... the worksheet's identifying tab at
the bottom of the worksheet or the entire worksheet itself?

 

[newguy]

Based on the wording of your latest post, I think I need a clarification
please. Perhaps you and I are using the word "tabs" differently... the tabs
I was talking about in my response is the small extension located at the
bottom of a worksheet that contains the name of the worksheet... your last
response makes me think you might be talking about the entire worksheet.
Exactly what do you want to be hidden... the worksheet's identifying tab at
the bottom of the worksheet or the entire worksheet itself?

Sorry about the confusion the entire worksheet is what I want to be
hidden.

 

[Rick Rothstein]

In that case... stick with the sub-thread Don started with you... his answer
is the one you are looking to implement.

--
Rick (MVP - Excel)

Based on the wording of your latest post, I think I need a clarification
please. Perhaps you and I are using the word "tabs" differently... the
tabs
I was talking about in my response is the small extension located at the
bottom of a worksheet that contains the name of the worksheet... your last
response makes me think you might be talking about the entire worksheet.
Exactly what do you want to be hidden... the worksheet's identifying tab
at
the bottom of the worksheet or the entire worksheet itself?

Sorry about the confusion the entire worksheet is what I want to be
hidden.