Delete a module

[Steve M]

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
>