Hi John,

Here's some code for a check box (originally sourced from Aaron Blood's
highlight.zip file at http://www.xl-logic.com/pages/vba.html):

Private Sub CheckBox1_Click()
If Sheets(1).CheckBox1 Then
'code for hiding rows
else
'code for unhiding rows
End If
End Sub

Nb: depending on your preference/caption in your check box, it may be
better around the other way.

Or another option is just to turn one of your two buttons into a toggle
& delete the other one. Have a look at thread below for ideas to adapt:
http://excelforum.com/showthread.php...=toggle+button

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=535769