Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Macro from VBA
I have created an Auto_Open macro in a template. I want to delete this
macro using VBA code after it runs the first time. How do I delete existing Macros from VBA? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Macro from VBA
Hi Nuraq,
See Chip Pearsons 'Programming to the Visual Basic Editor' page at: http://www.cpearson.com/excel/vbe.htm In particular, look for the section entitled: Deleting A Module From A Workbook and see Chip's Sub DeleteModule() routine. --- Regards, Norman "Nuraq" wrote in message ... I have created an Auto_Open macro in a template. I want to delete this macro using VBA code after it runs the first time. How do I delete existing Macros from VBA? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Macro from VBA
I second the resource suggestion Norman has indicated, and want to emphasize
this point which Chip Pearson already emphasizes but cannot be over-emphasized: NOTE: Many macro-based viruses propagate themselves by writing code using the methods described on this page. Therefore, many if not all virus scanning programs will automatically delete code that manipulates VBA code. Some programs will delete the entire code module. You may want to turn off your virus scanner when working with workbooks that manipulate VBA code projects. "Norman Jones" wrote in message ... Hi Nuraq, See Chip Pearsons 'Programming to the Visual Basic Editor' page at: http://www.cpearson.com/excel/vbe.htm In particular, look for the section entitled: Deleting A Module From A Workbook and see Chip's Sub DeleteModule() routine. --- Regards, Norman "Nuraq" wrote in message ... I have created an Auto_Open macro in a template. I want to delete this macro using VBA code after it runs the first time. How do I delete existing Macros from VBA? |
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 |