Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Row
I am working on an excel document where when a specific cell says no a row
will hide. This is the code I am using: Private Sub Worksheet_Calculate() If Worksheets("Interview").Range("A28").Value = "No" Then Worksheets("Interview").Range("E29").EntireRow.Hid den = True If Worksheets("Interview").Range("A28").Value = "Yes" Then Worksheets("Interview").Range("E29").EntireRow.Hid den = False End Sub It will run fine when I place a no in the cell and go to the visual basic and hit play, but I want it to run automatically. I wan the row to hide once the cell says no, so you don't have to go to the visual basic editor and hit play. Any suggestions? thank you, Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |