I want to put a command button on m

[bnageshrao]

I want to put a command button on my first sheet and when i click on it I want it to show me second sheet by hiding the first sheet and vice versa. I used the statement Activesheet.hide and the show command for the other and it came out with an error.

 

[dsi]

Code for Command Button on Sheet1

Private Sub CommandButton1_Click()
    Sheets("Sheet2").Visible = xlSheetVisible
    Sheets("Sheet2").Select
    Sheets("Sheet1").Visible = xlSheetHidden
End Sub

Code for Command Button on Sheet2

Private Sub CommandButton1_Click()
    Sheets("Sheet1").Visible = xlSheetVisible
    Sheets("Sheet1").Select
    Sheets("Sheet2").Visible = xlSheetHidden
End Sub

 

[Guest_imported]

Thanks and it worked.

 

[LoNeRaVeR]

bnageshrao:

Of course it worked. dsi knows this stuff very well! s-)

LoNeRaVeR

 

[dsi]

I have learned some stuff from you as well! Thanks!