Check box

[bakerman]

I have created six check box's on my first sheet named "ASK !" what i want to do is hide - unhide worksheets dependant on whether or not a check box is ticked. ie if check box 1 is ticked then sheet 2 and 3 would be visable and if check box 2 is ticked sheets 3 and 4 would be visable.

 

[SteveO59L]

Which toolbox did you use to create the tickboxes?

 

[bakerman]

I created the check box's in forms

 

[SteveO59L]

Have a play around with something like this

Application.ScreenUpdating = False

Sheets("Sheet3").Activate
ActiveSheet.Visible = False


You will need to create a macro and copy the above into it, then attach it to your checkbox.

 

[bakerman]

Not quite what i was looking for. I am trying to hide and unhide worksheets. The code you gave me only unhides a worksheet

 

[SteveO59L]

Just change the visible line to True/False, depending on whether you want to hide/unhide

 

[bakerman]

This is the code i have running, is it possible to change

Application.Run "'Copy of A Shift Holidays.xls'!Macro1"
Sheets("OP'S 06-07").Visible = True
Sheets("ASK !").Select
End Sub

Visible = true to
visible = cell v23

 

[SteveO59L]

Application.ScreenUpdating = False
If Range("a1").Value = "True" Then

Sheets("Sheet3").Activate
ActiveSheet.Visible = True
End If
If Range("a1").Value = "False" Then

Sheets("Sheet3").Activate
ActiveSheet.Visible = False
End If

 

[bakerman]

Thanks for your time, it is working fine