Is there a way to use option buttons to easily hide and unhide a group of cells?
Is there a way to use option buttons to easily hide and unhide a group of cells?
Hi Eclind
Definitely! Just record 2 sets of macro to hide and unhide the cells you want, then assign the macros to the 2 different option buttons.
scwi :D
Example code for using two option buttons (op1 and op2) on a worksheet (one to hide rows 1:4, the other to unhide them):
It might make more sense to use a checkbox instead, rather than two option buttons. You could then have the code determine if the checkbox is checked or not, and hide/unhide the rows accordingly.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks