Delete calling macro button by VBA

Hi

I have a VBA macro in a workbook which is invoked by clicking on a command button in a worksheet.

It is intended that the macro only ever be invoked once in the workbook. (Basically, the user puts some initialising data into a separate dedicated worksheet in the template workbook, runs the macro which does various things one-off with the initialising data, then deletes the worksheet containing that data.)

The macro already contains code which prevents its execution twice, but to tidy up the workbook I would also quite like it if the command button used to invoke it is also deleted from the workbook at the conclusion of the first execution of the macro. Can someone please give me guidance on that instruction?

Thanks.

All rather depends on the nature of the control used - is the button an Active X button or a Forms button ? On which sheet does it reside ?

Active X (ie using Click Event)

Please Login or Register  to view this content.

Forms Control (ie macro "assigned")

Please Login or Register  to view this content.