View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default 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.
.