VBA Macro "Security" Issue

Question

I'm writing a macro for work and was able to run it yesterday before I left.  I came in this morning and I cannot exit designer mode; I receive an error "Cannot run the macro 'ABC'.  The macro may not be available in this workbook or all macros may be disabled.  However, I am able to run a previously written macro without any issue.

My first step was to go into the macro settings (Developer tab > macro security > macro settings) to ensure "Enable all macros" option was clicked.  It is.  I then tried running the macro through the visual basic debugging tool (where you enter the code, change userforms / modules, etc.) When I try to manually run the macro, it says "The macros in this project are disabled.  Please refer to the online help or documentation of the host application to determine how to enable macros."  

I would believe this could be a security issue on my computer (firewall or otherwise), but again, I can run a previously written macro without any issue.

Any suggestions on where to start?

Answer 1

I solved my own issue - in case anybody else reads this:

Above the "macro settings" is "ActiveX Settings" - I had "Prompt me before enabling all controls with minimal restrictions" checked.  Changing this to "Enable all controls without restrictions" allowed it to run.