Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro delete itself?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro delete itself?
Hi Mike,
Sure, see Chip Pearson's page. Coding to the VBE http://www.cpearson.com/excel/vbe.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "OceansideDJ" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro warning - how to delete macro | Excel Worksheet Functions | |||
delete a macro that isn't in macro list | Excel Discussion (Misc queries) | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming |