Remove CommandButton

S

SS

I have added a commandbutton to my worksheet through a
macro. When the button is clicked, I want it to do a
series of things including get rid of the button (whether
it is deleted, hidden, etc.. I don't care I just want it
to not be on the screen any more.)

I am not suceeding at this.

Suggestions?

Thanks

SS
 
J

Jim

SS:
Set the CommandButton's Visible property to False.

Workbook.Worksheets("Sheet1").Shapes("CommandButton1").Visible = False

Jim
 

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

Shortcut key to commandbutton 3
Commandbutton question 2
Deselect a Commandbutton 3
To hide UserForm command buttons 4
CommandButtons have stopped working 2
CommandButton Link to Macro 2
Duplicate CommandButton macros 4
Size of CommandButton changing while not expected ! 1

Top