Thanks Dave! I'll attempt to write this

Cindy Johnso
----- Dave Peterson wrote: ----

I think I'd use two macros

The first macro would hide the row (and associated checkbox) and the secon
would unhide both the rows and the checkboxes

Option Explici
Sub HideRow(
Dim myCBX As CheckBo

For Each myCBX In ActiveSheet.CheckBoxe
With myCB
.Visible = CBool(.Value = xlOn
.TopLeftCell.EntireRow.Hidden = CBool(.Value = xlOff
End Wit
Next myCB

End Su
Sub ShowCBX(
With ActiveShee
.Rows.Hidden = Fals
.CheckBoxes.Visible = Tru
End With
End Su



Cindy wrote
Forms toolbar
Thanks for the reply
Cindy Johnso
----- Tom Ogilvy wrote: ----
What kind of checkboxes - control toolbox toolbar or forms toolba
-
Regards
Tom Ogilv
Cindy wrote in messag
..
I have created a spreadsheet with check boxes. If the box is not checked
then I want to delete/collapse the rows. How do I create a macro to d
this?
Thanks


--

Dave Peterso