Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code
Good day.
I have created check boxes that control hiding and unhiding columns and rows in one workbook writing the following code to control the hiding and unhiding. Private Sub Worksheet_Calculate() If Range("b5").Value = False Then Columns("c:p").EntireColumn.Hidden = True Else Columns("c:p").EntireColumn.Hidden = False End If End Sub I have since opened a new workbook, created another checkbox and used the same code with absolutely no luck. I have checked my Macro settings in both, which are both set to "low". I am completely baffled. Any suggestions? -- Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |