Ron
I did that and the file now is an xlsx file. All the code is there and
it runs!! Did I miss something? Each time I save it, it warns me that I
will lose all my code. I click Yes and the code is still there. 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