Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use checkbox to hide rows
I have set up a macro to unhide 5 rows on a worksheet and have also set up
another one to unhide the same 5 rows. I have set up a checkbox and have been able to use VB editor to run the 'hide' macro when the box is checked - how do I use VB to unhide the rows when the box is unchecked? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
use checkbox to hide rows
In the macro, test the value and hide/unhide accordingly.
Rows("5:10").Hidden = ActiveSheet.CheckBoxes(Application.Caller).Value = 1 -- __________________________________ HTH Bob "ScottB" wrote in message ... I have set up a macro to unhide 5 rows on a worksheet and have also set up another one to unhide the same 5 rows. I have set up a checkbox and have been able to use VB editor to run the 'hide' macro when the box is checked - how do I use VB to unhide the rows when the box is unchecked? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
use checkbox to hide rows
In the macro, test the value and hide/unhide accordingly.
Rows("5:10").Hidden = _ ActiveSheet.CheckBoxes(Application.Caller).Value = 1 -- __________________________________ HTH Bob "ScottB" wrote in message ... I have set up a macro to unhide 5 rows on a worksheet and have also set up another one to unhide the same 5 rows. I have set up a checkbox and have been able to use VB editor to run the 'hide' macro when the box is checked - how do I use VB to unhide the rows when the box is unchecked? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to Unhide Rows | Excel Discussion (Misc queries) | |||
cut rows without cutting hide rows | Excel Discussion (Misc queries) | |||
deleting mulitple rows when the checkbox value = true. | Excel Discussion (Misc queries) | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
Checkbox to hide and unhide rows Please. | Excel Worksheet Functions |