View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DarrenL DarrenL is offline
external usenet poster
 
Posts: 13
Default reverse a "hide" function

Current code:

Private Sub CheckBox1_Click()
Range("A10:A28").EntireRow.Hidden = CheckBox1.Value
End Sub

I need to reverse the checkbox. Currently, when it is checked, the rows hide.
I need it to do the opposite.
Anyone?
Thanks
D