Hello
I am trying to hide or show an object based on a cell value on another sheet. Below is the code I am trying, but it's not working.
A25 on sheet "Enter Data Here" Will always be true or false.
The "object" is word art that I have named "HSV_Warn"
Hope someone can help. Maybe I am going about this the wrong way?
PHP Code:
Private Sub HSV_Warn(ByVal Target As Range)
If Sheets("Enter Data Here").Range("A25").Value = True Then
Sheets("Binder Cover").Object("HSV_Warn").Visible = True
Else
Sheets("Binder Cover").Object("HSV_Warn").Visible = False
End If
End Sub
Bookmarks