Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box reversal
I want to use a check box to hide some cell and unhide the same. So, when
the check box is checked I am using a macro to hide the cells, but then how do I get the cells unhided since a check box can only assign one macro. Suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box reversal
I'm not sure what the nature of the cells you're hiding, but I played with a
column and set the hidden property to the linked cell value of a check box. Say your check box is linked to a cell named "cbout". the following line of code hid column f: Column("f:f").hidden = range("cbout").value I assigned that macro to the check box and was hiding and unhiding column F to my hearts content. I don't know if that will apply to your application, but I hope it helps. E.Q. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box reversal
E.Q. - Thanks a lot. That works great and it is so simple. Sometimes one
can't see the forest because of the trees. TDC "E.Q." wrote: I'm not sure what the nature of the cells you're hiding, but I played with a column and set the hidden property to the linked cell value of a check box. Say your check box is linked to a cell named "cbout". the following line of code hid column f: Column("f:f").hidden = range("cbout").value I assigned that macro to the check box and was hiding and unhiding column F to my hearts content. I don't know if that will apply to your application, but I hope it helps. E.Q. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Line Chart Axis Reversal | Charts and Charting in Excel | |||
Data Order Reversal | Excel Discussion (Misc queries) | |||
check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) |