Macro programing in excell
 

I am trying to creat a excel(2003) sheet that when you click on a button
(yes/no) certin cells will dissapear. hide. and when you click on the other
button they reapear.
I will have several sections that this will apply.

let me know if there are any suggustions

Macro programing in excell
 

How about using the SAME button
Sub togglehiderows()
Rows("2:4").Hidden = Not Rows("2:4").Hidden
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"thechad85" wrote in message
...
I am trying to creat a excel(2003) sheet that when you click on a button
(yes/no) certin cells will dissapear. hide. and when you click on the
other
button they reapear.
I will have several sections that this will apply.

let me know if there are any suggustions