hide and unhide worksheet

TiggerToo · Mar 30th, 2004, 03:01 PM

hello all,

I need a little more instructions on why this VBA code does not work the way it suppose too:
I put the correct cell in place $K$23, now I want to hide a worksheet called "DutyCode" when info!$k$23 is blank or has "xx" or "XX" in the cell, and then unhide "DutyCode" when the number 27 is inputed in info!$k$23

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$k$23" Then Exit Sub
If Target.Value = 1234 Then
Worksheets("Sheet2").Visible = True
Else
Worksheets("Sheet2").Visible = False
End If
End Sub

any and all help is gladly tried and tested
Thanks
Walt

Mar 30th, 2004, 03:01 PM	#1
TiggerToo Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 116	hide and unhide worksheet hello all, I need a little more instructions on why this VBA code does not work the way it suppose too: I put the correct cell in place $K$23, now I want to hide a worksheet called "DutyCode" when info!$k$23 is blank or has "xx" or "XX" in the cell, and then unhide "DutyCode" when the number 27 is inputed in info!$k$23 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$k$23" Then Exit Sub If Target.Value = 1234 Then Worksheets("Sheet2").Visible = True Else Worksheets("Sheet2").Visible = False End If End Sub any and all help is gladly tried and tested Thanks Walt

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode