| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| differentiate between a visible and a hidden userform | Excel Programming | |||
| Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. | Excel Programming | |||
| Making sheets visible / hidden | Excel Programming | |||
| Visible Sheet Showing When Hidden | Excel Programming | |||
| Check status row (hidden or visible)? | Excel Programming | |||
![Matt[_40_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
