h,

Since you are new, you will find the following useful...
http://www.cpearson.com/excel/newposte.htm

Jim Cone
San Francisco, USA


"haitch2" wrote in message
...
Hi
Im very inexperiance with VBA so please be gental Im trying
to learn
right i have a small bit of code conected to a macro to hide/show
worksheets when a check box is toggled.
Sub Macro1()
If Worksheets("2").Visible = True Then
Worksheets("2").Visible = False
If Worksheets("3").Visible = True Then
Worksheets("3").Visible = False
Else
Worksheets("2").Visible = True
Worksheets("3").Visible = True
End If
End Sub
It hides the sheets but i cant get them to reapear again.
i can get it to work for one sheet but not 2.
Thanks for any help