Hide Sheet If....
Success! Thanks.
-----Original Message-----
If Sheets("ASP").Range("AE46").Text = "TRUE" Then
or
If Sheets("ASP").Range("AE46")Value = TRUE Then
--
Regards,
Tom Ogilvy
"JP" wrote in
message
...
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.
.
.
.
|