Ron
After saving it as an xlsx file, I closed the file. Closed Excel.
Opened Excel and the file and the code is gone. Otto

"Ron de Bruin" wrote in message
...
Save the file as xlsx and all your code is gone

Maybe this page will help
http://www.rondebruin.nl/saveas.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Otto Moehrbach" wrote in message
...
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