I would like to use a checkbox to hide(when checked)/unhide(when not checked) rows under a header. For example, I have a row of data in row 10. This data is compiled by summing columns in rows 11-20. I would like to be able to keep rows 11-20 hidden until the checkbox is checked, then they would be visible. Then when the checkbox is unchecked, the rows would hide again. I am very new at writing macros and VB. Thanks