Removing a macro button after execution

  • Thread starter Thread starter Bishop
  • Start date Start date
B

Bishop

I have created a button and have assigned a macro to it. How do I code the
existing macro to delete the button once the macro has executed?
 
Hi

Why not just make the button invisible?
Well, the below macro gives an example of both solutions.


Private Sub CommandButton1_Click()
msg = MsgBox("Hello")
Me.CommandButton1.Visible = False
'Me.CommandButton1.Delete
End Sub

Regards,
Per
 
The trick is to know the name

Sub deleteshapeafterrunningmacro()
MsgBox "hi"
With ActiveSheet
.Shapes("Rectangle 3").Cut
End With
End Sub
 

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

Conditional Macro execution based on a variable 3
Assigning macro buttons to macro code in another file 2
Run Macro If Cell have "x" value 0
How to call Excel add-in macro from a button… 1
Re: Reference must be to a macro sheet? 0
Command Button Question 8
Unable to assign macros to a new button in the current worksheet 1
Macro execution changes filename reference for all macros 1

Back
Top