I dont know whats the trouble  in this, as long as I can see the
code. You said you want to hide  the worksheet.

You can specify it as

Worksheets("Sheet1").Select
Selection.Hide

or

Worksheets("Sheet1).Visible = False
Worksheets("Sheet2").Visible = False.

Either of the statements can be used. But i dont know, when exactly
you want to hide the sheets. For eg: either when you open the
workbook, you can hide the sheets which you told or before you close
the application, you can hide the sheets.

When you talked about unhiding the sheets. specify in the button
event handler, the sheet  name. For eg:

Private Sub CommandButton1_click()
Worksheets("Sheet1").Visible = True
Worksheets("Sheet2").Visible = True
End Sub