Jim Rech wrote:

You should add a macro that runs when your workbook is closed (Sub
Auto_Close or the Workbook_Close event handler) to delete your custom
toolbars/menu items.

I had been wondering about this, but was reticent to try because I thought
it might result in a global deletion of the custom toolbar.


Then when the original workbook is opened its
custom additions will not be blocked by the ones belonging to the
"save as" copy.

Okay, I'll give this a try. Ideally, I'd like to strip everything out of the
SaveAs spreadsheet and turn it into a plain workbook with no macros or
toolbars. I've just been messing around with the Workbook_BeforeSave event
to create a new workbook and assign it an arbitrary name, which works, so
I'll try deleting the custom toolbar/menu bits.



--
Wally
www.forthsailing.com
www.wally.myby.co.uk