#1   Report Post  
Steve M
 
Posts: n/a
Default 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.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
  #3   Report Post  
Steve M
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot delete a macro Jeff B Excel Discussion (Misc queries) 3 February 15th 05 12:43 AM
How to delete macros Jaime Stuardo Excel Discussion (Misc queries) 2 February 14th 05 02:29 PM
delete row contains specific word in an macro Jean-Francois Excel Discussion (Misc queries) 4 January 11th 05 11:40 PM
Saving to a network share without delete permssions SteveHoot Excel Discussion (Misc queries) 1 January 5th 05 09:50 PM
Difference in the listing of the New module addition in 2002 version Hari Excel Discussion (Misc queries) 2 January 4th 05 06:56 AM


All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"