Hi Danny

Only with VBA code or if there is no code in the sheet modules you can do this

Right click on a sheet tab and choose "Select all sheets"
Right click again and choose "Move or copy"
In the "to book" list choose new workbook
check "create a copy"

You have now a new workbook with all the sheets


--

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


"Danny" wrote in message ...
If there a way to delete all the macros if the workbook is saved with another
name?

Thanks,

Danny