Show and Hide a section of cells w a Checkbox Macro

Hi all,

Im working with excel for mac 2007 and am trying to show and hide a section of cells when you click a checkbox macro but cant seem to find a tutorial on this.

I would like to have it at the side and then hide a certain number of rows. Can anyone help w this macro or a link to a guide for this?

Thanks!

thanks marvin. I just checked and VBA does work.

below is the code that i have. basically the checkbox works to hide it but when i click it the second time it does not unhide it...any thoughts?

Sub Hide()
'
' Hide Macro
'
' Keyboard Shortcut: Option+Cmd+g
'
Rows("13:17").Select
Selection.EntireRow.Hidden = True
End Sub
Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Option+Cmd+j
'
Rows("13:17").Select
Selection.EntireRow.Hidden = False
End Sub

nevermind figured it out

Sub CheckBox1_Click()

If Range("A4").Value = True Then
Rows("13:17").EntireRow.Hidden = False
Else
Rows("13:17").EntireRow.Hidden = True
End If

End Sub