Cliffork
New Member
- Joined
- Feb 12, 2020
- Messages
- 43
- Office Version
- 365
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?
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?
VBA Code:
'Hides/unhides EPA verification page
If [B18] = "True" Then
Sheets("EPA Verification").Visible = True
Else
Sheets("EPA Verification").Visible = False
End If