Check Box

[John]

I currently have two buttons. One that will show the hidden rows, the other
that will hide them again. However, i would rather change the two buttons to
a check box. So if the check box is "Checked" it will show the hidden cells,
but if it is unchecked it will hide the cells again. I assume that is
possible.

[broro183]

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
'your code for unhiding rows
else
'your code for hiding rows
End If
End Sub

Nb: depending on your preference/caption in your check box, it may be better around the other way. (edit: just re-read your post & have flicked comments around)

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...