Turning off all the mac ros and code in an Excel Workbook

  • Thread starter Thread starter Ian M
  • Start date Start date
I

Ian M

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for all Excel Workbooks to print to PDF 2
How to split an excel workbook in code and data 2
Shared Workbook Crash 0
Windows XL, Mac XL, and the Ribbon? 6
Opening a list of Excel files and run a macro in each 17
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel VBA UserForms in in Mac OS X 2
Macro to open file and copy information from worksheet 1

Back
Top