A Macro to hide and unhide Rows

Microsoft Excel 2003 (full product)
January 6, 2011 at 02:19:46
Specs: Windows XP
I inserted a checkbox in excel and now wish to run a macro on this check box.

If the checkbox is ticked unhide certain rows, however if it is not ticked it stay's hidden, also the macro needs to re hide the rows if the checkbox is then subsquently unticked.



See More: A Macro to hide and unhide Rows

Report •

January 10, 2011 at 15:53:47
How about this..

Private Sub CheckBox1_Click()
  If CheckBox1.Value = True Then
    Rows("5:10").Hidden = False
    Rows("5:10").Hidden = True
  End If
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question