Is there any way when a workbook is saved as that the new workbook doesn't
keep the code from the main workbook.

Thanks Mike

Hi Mike

Excel version ?

In 97-2003 if there is no code in the sheet module's you can use

Worksheets.Copy

This create a new workbook with all worksheets without the modules and the code in the thisworkbook module.
You can save this workbook then

Or use Chip's code
http://www.cpearson.com/excel/vbe.htm


Excel 2007

Save the workbook as xlsx (macro free workbook) and it will remove all code.


--

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


"Mike" wrote in message ...
Is there any way when a workbook is saved as that the new workbook doesn't
keep the code from the main workbook.

Thanks Mike

http://www.cpearson.com/excel/vbe.htm

has sample code for deleting code.

--
Regards,
Tom Ogilvy

"Mike" wrote in message
...
Is there any way when a workbook is saved as that the new workbook doesn't
keep the code from the main workbook.

Thanks Mike