Possibly put the code in an addin. This separates the code from the
workbook.

--
Regards,
Tom Ogilvy

"nospaminlich" wrote in message
...
Thanks a lot for the replies.

I've at least now proved that by disabling macros the file still won't
open.

If I maually save the file without without removing shapes and sheets it's
fine but
that leaves users able to run macros in the copy version which I don't
want.

Any ideas what it could be in the code I posted above that is causing the
saved file to corrupt?

Is there a more reliable way of writing the code?

Thanks again

Keith