Hide sheet tabs?

[robotman]

Is there any way to hide sheet tabs?

Thanks.

 

[Earl Kiosterud]

Botman,

Tools - Options - View. Sheet tabs.

 

[Stephen Bye]

Tools | Options | View
uncheck "Sheet tabs"

 

[robotman]

I should have clarified. I only want to hide SOME of the sheet tabs.

Any way to do this?

Thanks...

 

[Dave Peterson]

You either see all the tabs at the bottom of the screen or you see none of them.

But if you really meant that you wanted to actually hide the worksheets
themselves...

Select the sheets you want to hide.
click on the first tab, and ctrl-click on the subsequent.
then format|sheet|hide

 

[robotman]

Nah... I really wanted to hide just some of the tabs within a single
workbook. I didn't think it was possible, but I thought I would ask.

If I do hide all the tabs, how do I jump to the different sheets in a
workbook?

Thanks.

 

[Dave Peterson]

ctrl-pgup, ctrl-pgdn
is one way to cycle through the worksheets.

 

[ilia]

"(e-mail address removed) пиÑал(а):
"

Nah... I really wanted to hide just some of the tabs within a single
workbook. I didn't think it was possible, but I thought I would ask.

You can - each worksheet has a Hidden property.

I do it from VBA properties - there you can also make it so that they
cannot be unhidden from within the Excel GUI (xlVeryHidden, or 2).

 

[Dave Peterson]

I think robotman wants to keep the worksheets visible, but hide the associated
tabs for a few worksheets. He actually means the little tab at the bottom of
the window.

 

[ilia]

I was thinking about that since replying - what is the purpose, if you
don't mind me asking?


"Dave Peterson пиÑал(а):
"

 

[Dave Peterson]

I have no idea.

Robotman????

I was thinking about that since replying - what is the purpose, if you
don't mind me asking?

"Dave Peterson пиÑал(а):
"

 

[robotman]

I'm getting confused.

I have a workbook with about 10 worksheets in it. I want to hide 5 of
the worksheets (and their associated tabs) to clean up the look of the
workbook.

I can't find the hidden attribute. For example:

sheets("Sheet1").hidden = true

Doesn't seem to work. Get's "Object doesn't support this property"
error.

 

[Dave Peterson]

Try

Sheets("sheet1").visible = xlsheethidden ' or xlsheetveryhidden

Lots of times, you can record a macro when you do it manually to get the code to
use.

From a previous response in this thread:

But if you really meant that you wanted to actually hide the worksheets
themselves...

Select the sheets you want to hide.
click on the first tab, and ctrl-click on the subsequent.
then format|sheet|hide