Hide Sheet If....
Thanks for your response. Unfortunately, I get a "Type
Mismatch" error for:
If Sheets("ASP").Range("AE46") = "TRUE" Then
Sheets(" Scorecard").Visible = False
Else: Sheets(" Scorecard").Visible = True
End If
-----Original Message-----
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.
.
.
|