Hiding/unhiding a sheet based on a cell value

[Cliffork]

Hello,

I have been having an issue with this code lately that is supposed to hide/unhide a sheet dependent on if cell B18 says "True" or "False". Generally what happens is if I enter TRUE to unhide the sheet, it will appear. But within a few minutes it will re-hide itself. I generally get to the step where I need that form in my workflow about 30-40 minutes after I filled in this true/false question, and it will have re-hidden itself. Can anyone help me either fix or replace this code so that it will remain unhidden if B18 still has "True" as its value?

'Hides/unhides EPA verification page
    If [B18] = "True" Then
    Sheets("EPA Verification").Visible = True
    Else
    Sheets("EPA Verification").Visible = False
    End If

 

[dmt32]

Hi,
try

Sheets("EPA Verification").Visible = Range("B18").Value = True

Dave

 

[Cliffork]

Hi,
try

Sheets("EPA Verification").Visible = Range("B18").Value = True

Dave

This seems to have worked, thank you!