If a certain cell has a certain value, a certain worksheet is hidden or visible
Hello Everyone:
I have a cell named "Input_StepRatePerformed". It has a drop down
list (I am using Data/Validation from the Toolbar) with Yes and No as
the only two choices. What I want to do is if Yes is in the cell, the
worksheet named "SRT" is visible. If No is selected then "SRT"
worksheet is hidden. I have tried some different code such as
worksheet change with no success. I am not sure where to begin. Any
help is greatly appreciated. Thanks in advance.
Matt
|