hiding forms button
 

I guess the name says it all I'm wondering if there's anyway to hade a
form button. I want to creat a macro that will hide all the forms
button and protect the sheet

when I try to just hide the columns it just moves the buttons to the
right and leaves them there.

please help a newb...


--
bigtonyicu
------------------------------------------------------------------------
bigtonyicu's Profile: http://www.excelforum.com/member.php...o&userid=22430
View this thread: http://www.excelforum.com/showthread...hreadid=395117

bigtonyicu,

Private Sub CommandButton2_Click()
CommandButton1.Visible = False
End Sub

and to show it again:

Private Sub CommandButton3_Click()
CommandButton1.Visible = True
End Sub

Henry

"bigtonyicu" wrote
in message ...

I guess the name says it all I'm wondering if there's anyway to hade a
form button. I want to creat a macro that will hide all the forms
button and protect the sheet

when I try to just hide the columns it just moves the buttons to the
right and leaves them there.

please help a newb...


--
bigtonyicu
------------------------------------------------------------------------
bigtonyicu's Profile:
http://www.excelforum.com/member.php...o&userid=22430
View this thread: http://www.excelforum.com/showthread...hreadid=395117