How to hide only 2 cells using macros?

Closed
The Game - Jan 12, 2009 at 03:57 AM
shirro Posts 11 Registration date Saturday November 15, 2008 Status Member Last seen May 19, 2009 - Jan 12, 2009 at 05:57 AM
Hello,

I have a checkbox for which I have already assigned a macro:

Private Sub CheckBox9_Click()

If (CheckBox9.Value = False) Then
toggle False, False
Else
toggle True, False
End If
End Sub.

Now I want to make some changes in the above code where If I check that check box in addition to the toggle effect it also hides/shows 2 specifice cells "C9 and D9". Is there any way by which I can do it?

Thanks in advance for your help.
Related:

1 response

shirro Posts 11 Registration date Saturday November 15, 2008 Status Member Last seen May 19, 2009 1
Jan 12, 2009 at 05:57 AM
hi,
try this link:
http://www.alltipsandtricks.com/how-to-use-macros-in-ms-excel/
hope it helps you.
0