See Chip's site for programmatically removing VBA from a workbook.

http://www.cpearson.com/excel/VBE.aspx


Gord Dibben MS Excel MVP


On Sun, 13 Dec 2009 12:48:30 -0500, "Otto Moehrbach"
wrote:

Excel 2007 Win 7 64-bit
I have a wb with VBA code that does various things. The code then savesAS
the wb in another name. At that point, I want the same code to remove all
code from that wb and save the wb. Can that be done and how? Thanks for
your time. Otto