View Toolbars Visual Basic
On the Visual Basic Toolbar click Security Security Level High
This will ask you to enable Macros when workbook opens you can choose No

----- Ian M wrote: -----

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