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