hiding forms button

B

bigtonyicu

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

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

please help a newb..
 
H

Henry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change macro button text when macro is invoked. 2
hiding columns in Excell error message 2
Button commands or hyperlinks 4
stationary command button 2
Hiding Columns 2
hiding the cell and the formula bar 2
Macro to hide sheets based upon cell value 3
hiding columns 1

Top