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,

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Use activesheet.shapes("Button 1").visible = false
"Button 1" is the name of your form control button