ExcelBanter - Delete a module

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Delete a module (https://www.excelbanter.com/excel-discussion-misc-queries/19441-delete-module.html)

Steve M

Delete a module

How can I delete a module from VBA? What I have is a macro that is in a
template. After the macro runs and I go to save the spreadsheet, I would like
to delete the macro and all code.

Dave Peterson

Chip Pearson has lots of info about this kind of thing at:
http://www.cpearson.com/excel/vbe.htm

Steve M wrote:

How can I delete a module from VBA? What I have is a macro that is in a
template. After the macro runs and I go to save the spreadsheet, I would like
to delete the macro and all code.

--

Dave Peterson

Steve M

Thanks Dave, Site looks like it has what I'm looking for.

"Dave Peterson" wrote:

Chip Pearson has lots of info about this kind of thing at:
http://www.cpearson.com/excel/vbe.htm

Steve M wrote:

How can I delete a module from VBA? What I have is a macro that is in a
template. After the macro runs and I go to save the spreadsheet, I would like
to delete the macro and all code.

--

Dave Peterson

All times are GMT +1. The time now is 10:44 PM.