Setting the visibility of the sheet on button click (Hide/Unhide)

Sub Hide_Click()

Worksheets("Sheet2").Visible = False

End Sub
Sub Unhide_Click()
Worksheets("Sheet2").Visible = True
End Sub