Can a macro delete itself?

O

OceansideDJ

My auto_run macro imports a text file, formats a report, asks the user for a
FileSaveAs filename, and finally saves a copy of the spreadsheet.

Now, I do not want the macro to run again, in this saved copy. Can the macro
delete itself, or rename itself, or disable itself, or save a copy of the
spreadsheet with no macros? Anythng to never run again.

Thanks,

Mike
 

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

call a macro in another worksheet? 2
Macro to delete an Object 1
Copy data using macro (with worksheet protect) 5
macro confusion 3
Macro to delete macro? 4
Ensuring Macros are running 2
Macro to delete part of a macro 1
Removing Macro/Deleting a Button in a Spreadsheet 5

Top