How do I enable macros?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open a macro I get an error message saying "The macros in this project
are disabled. Please refer to the online help or documentation of the host
application to determine how to enabl macros."

How can I get them enabled??
 
Ben Jenkinson said:
When I open a macro I get an error message saying "The macros in this
project
are disabled. Please refer to the online help or documentation of the host
application to determine how to enabl macros."

How can I get them enabled??
Click to expand...

Hi Ben,

From the Excel menu choose Tools/Macro/Security and make sure the Medium
option button is selected on the Security Level tab. Restart Excel and
reopen the workbook containing macros. Excel will display a message telling
you the workbook contains macros and give you the option to enable or
disable them. If you're sure you know where they came from you can enable
them.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
 
Thanks very much. This has helped a lot.

Rob Bovey said:
Hi Ben,

From the Excel menu choose Tools/Macro/Security and make sure the Medium
option button is selected on the Security Level tab. Restart Excel and
reopen the workbook containing macros. Excel will display a message telling
you the workbook contains macros and give you the option to enable or
disable them. If you're sure you know where they came from you can enable
them.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
Click to expand...
 
Back
Top