Hide sheet tabs?

R

robotman

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

Any way to do this?

Thanks...
 
D

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
 
R

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

ilia

"[email protected] пиÑал(а):
"
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.
Click to expand...


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).
 
D

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

ilia

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


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

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 пиÑал(а):
"
Click to expand...
 
R

robotman

I'm getting confused. :cool:

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

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
 
Top