hi
you can do it with a forms check box IF the check box is on a form. if not
and the check box is on the sheet then use the control check box.

Regards
FSt1

"dicko1" wrote:

Trying to assign a macro to a check box that will hide and unhide rows
depending on whether its checked or not. I can do it using a control
check box, but not a form check box. Any ideas?

Here is the code that works for the control check box:

Private Sub CheckBox1_Change()
If CheckBox1.Value = False Then
Issue_Mgt_Hide ( 'I assigned it to a different macro called
Issue_mgt_hide)
Else
Issue_Mgt_Unhide
End If
End Sub

Thanks for any help!

Ryan