use checkbox to hide rows

S

ScottB

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?
 
B

Bob Phillips

In the macro, test the value and hide/unhide accordingly.

Rows("5:10").Hidden = ActiveSheet.CheckBoxes(Application.Caller).Value =
1
 
B

Bob Phillips

In the macro, test the value and hide/unhide accordingly.

Rows("5:10").Hidden = _
ActiveSheet.CheckBoxes(Application.Caller).Value = 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Hide and Unhide Rows 2
Checkbox to Unhide Rows 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Create form with checkbox les that expand and collapse sections of the form? 0
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
hide, unhide column or row after protect worksheet 2
how can I lock/unlock a range of cells depending on state of a checkbox? 4
Hide Column 2

Top