Hiding a sheet

[smund]

I have a workbook Teste.xls
How can I hide a sheet "Plan1" in a macro?
Thanks

 

[pgc01]

Hi smund

Try:

Worksheets("Plan1").Visible = False

HTH
PGC

 

[Joe Was]

Sub myHideSht()
'

Sheets("Sheet3").Visible = False
End Sub

Sub myShowSht()
'

Sheets("Sheet3").Visible = True
End Sub



Smund, If you record a macro as you do the steps to do something, it will show you the code you need, when you view the recorded code in the editor!