Hide Sheet If....
Hi JPaul
You can use the following
Sub HideMySheet
If Sheets("Sheet1").Range("A1") = "good" Then
Sheets("sheet3").Visible = False
Else
Sheets("sheet3").Visible = True
End If
End Sub
Thanks
Greg
-----Original Message-----
Hi All,
As part of a greater routine, I'd like to Hide a
worksheet
if a certain condition exists in a cell located on a
different sheet. For example, If: Sheet1!A1 = TRUE, Hide
Sheet2.
Any help is appreciated.
.
|