hide sheets code

[JasonLeVan]

i am looking for code to hide and unhide sheets 1 and 2

 

[markf5998]

Sub Hide()
Sheet1.Visible = False
Sheet2.Visible = False
End Sub

Sub Unhide()
Sheet1.Visible = True
Sheet2.Visible = True
End Sub

 

[BrianExcel]

You can also do:

Sub Hide()
Sheet1.Visible = xlHidden (or xlveryhidden) if you don't want the user to be able to see it at all.
Sheet2.Visible = xlHidden (or xlveryhidden) if you don't want the user to be able to see it at all.
End Sub

Sub Unhide()
Sheet1.Visible = True
Sheet2.Visible = True
End Sub