| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding cells on condition
I am trying to hide a range of cells when the value in another cell is FALSE
and show the range of cells when the value is TRUE. My code is as follows but it doesn't work Private Sub Workbook_Open() If Range("C4").Value = False Then Range("E4:M40").Hide = True End If If Range("C4").Value = True Then Range("E4:M40").Unhide = False End Sub How do I make this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum of a cell if 2 cells meet a condition | Excel Worksheet Functions | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Hiding Formula in cells | Excel Discussion (Misc queries) | |||
| How to add cells wiht the condition of the former cell. | Excel Discussion (Misc queries) | |||
| condition format for surrounding cells | Excel Discussion (Misc queries) | |||
Threaded Mode
