Hiding worksheet

[Link]

Is there any way you can hide a worksheet in a workbook?

 

[Mike H]

Hi,

To hide it use

Sheets("Sheet1").Visible = False

or to prevent someone simply unhiding it use

Sheets("Sheet1").Visible = xlVeryHidden

Mike

 

[Link]

Do you click on the sheet tab?

Hi,

To hide it use

Sheets("Sheet1").Visible = False

or to prevent someone simply unhiding it use

Sheets("Sheet1").Visible = xlVeryHidden

Mike

 

[Mike H]

Hi,

It can go as worksheet code. Right click your sheet tab, view code and paste
this in and run it

Sub HideMe()
Sheets("Sheet1").Visible = xlVeryHidden

End Sub

Mike

 

[Gord Dibben]

Format>Sheet>Hide if you don't want VBA


Gord Dibben MS Excel MVP

 

[rslaughter5]

after using xlVeryHidden, how would I unhide the sheet in my workbook?

 

[Gord Dibben]

Sheets("Sheet1").Visible = True


Gord Dibben MS Excel MVP