View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_40_] Matt[_40_] is offline
external usenet poster
 
Posts: 19
Default 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