Hello,
I'm stuck so hopefully somebody can help me with this.
I'm trying to Hide or Unhide some sheets depending on the value of another cell.
I have this:
The problem is that it will only work if I manually write "YES" on the cell.
I would like it to work when this value appears on the cell through the following:
=IF(D3>0,"YES","NO")
Is there any way to achieve this?
Any other solution to get the sheet to Hide or Unhide depending on the value of D3 would be ok too.
Thanks!
I'm stuck so hopefully somebody can help me with this.
I'm trying to Hide or Unhide some sheets depending on the value of another cell.
I have this:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If [E3] = "YES" Then
Sheets("Sheet2").Visible = True
Else
Sheets("Sheet2").Visible = False
End If
End Sub
The problem is that it will only work if I manually write "YES" on the cell.
I would like it to work when this value appears on the cell through the following:
=IF(D3>0,"YES","NO")
Is there any way to achieve this?
Any other solution to get the sheet to Hide or Unhide depending on the value of D3 would be ok too.
Thanks!