Is there a way to enable Macros after the message bar with the Enable Macros button has closed?

I opened the Excel file and immediately went to edit the VBA. When I went to run the VBA, it stated,

The macros in this project are disabled. ...


Because of your security settings, macros have been disabled. To run macros, you need to re-open this workbook, and then choose to enable macros. ...

To get the Macro to run, I had to close the file and reopen the file to get the message bar and click the button to enable macros. While that procedure is not terribly painful, it is inconvenient.

I could allow ALL macros to run, but I would prefer to keep some security against malicious code.

Is there a way to get the message bar and/or Enable Macros button to reappear without reopening the file?

  • Are you using Excel on a computer managed by a Windows Domain? – David Dec 22 '15 at 21:14
  • David, not a windows domain, I'm on a network domain. – B540Glenn Dec 23 '15 at 13:50

If you trust the workbook running macros.

  1. Go to the Developer tab

  2. Click Macro Security Screenshot for steps 1 and 2

  3. Change it to enable all macros Screenshot steps 5 and 6

As far as I can tell, there is not way to make the "Enable Macros" button reappear.

We run macros frequently at work and do not open unknown files. So this works well and bypasses the "Enable Macros" message bar completely.

When you're done, you can always set it back to "not allow macros with notification".

This will solve your issue of having to reopen your file at least.

  • rencjam, I trust the macros that I and my team mates write, but we get files from customers often and I don't trust them. I guess I'll just have to remember to enable the content before I start editing the VBA. Thanks for the answer. – B540Glenn Dec 23 '15 at 13:52
  • You're welcome. My only other suggestion for files from customers would be to look over the code before running it. If it looks sound, then enable macros. – rencjam Dec 23 '15 at 16:06
  • Be very careful about leaving the Macro switched on, as we have seen a number of attacks come on to our corporate network with .doc files specifically designed to download and install key loggers. – David Dec 24 '15 at 14:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.