Button to run a macro

[snowboy001]

Putting together a macro right now to create a new sheet based off the previous sheets data. I am trying to create a button or something to that sort that is on each sheet that when you click it, the macro is ran, the new sheet is created, and the button that was just clicked is deleted. Any ideas on how to get this done?

 

[Andrew Poulsom]

What have you tried? You can assign your macro to a button from the Forms Toolbar.

 

[snowboy001]

Yes, but I need a way to delete the button after it is clicked. I only want the option to create the new sheet on the last sheet, and once that sheet is created, the buttons on the other sheets are deleted.

 

[Andrew Poulsom]

To delete the button:

ActiveSheet.Buttons(Application.Caller).Delete

 

[snowboy001]

Worked great. Thanks!