A macro to delete other macros?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a macro that makes a copy of the workbook that it's associated with.
Is it possible to modify this macro so that the copy of the workbook is
devoid of macros?

Thank you in advance for your help.

Ellen
 
Check out Chip Pearson's site:
http://cpearson.com/excel/vbe.htm

He shows how to write code that modifies code.

But there can be difficulties. If the workbook's project is locked or if the
user didn't allow any program access to the project, then you'll have trouble.
 
Thanks so much, Dave. Sounds like a winner!!

Dave Peterson said:
Check out Chip Pearson's site:
http://cpearson.com/excel/vbe.htm

He shows how to write code that modifies code.

But there can be difficulties. If the workbook's project is locked or if the
user didn't allow any program access to the project, then you'll have trouble.
Click to expand...
 
Did you follow Chip's instructions he writes in the "Introduction" at top of
page?

"In order to use the code on this page in your projects, you must change two
settings."


Gord Dibben MS Excel MVP


On Tue, 25 Aug 2009 10:39:01 -0700, Srinivasulu Vallela <Srinivasulu
 
The code on http://cpearson.com/excel/vbe.htm is not working for Excel 2007,
Click to expand...

The VBE object model wasn't changed between 2003 and 2007. The code
works in 2007. Can you provide an example of code that works in 2003
but not in 2007?

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Tue, 25 Aug 2009 10:39:01 -0700, Srinivasulu Vallela <Srinivasulu
 
Back
Top