I have a workbook in Excel in which Macros and VB Code perform a
certain amount of reformatting.

I now wish to save this Workbook under another name keeping all its
new formatting, but disabling all the VB code and macros that
performed the reformatting, as this has already served its purpose -
in particular, I want to get rid of the UserForms that appear
automatically when the Workbook opens.

Any ideas?

Kind regards

Ian M