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?