I'm working on a spreadsheet with macros and VBA. Until yesterday, whenever I opened the spreadsheet I would get a warning under the formula bar, and would have to press "Enable" to get macros to work. That message no longer appears when I open the spreadsheet. It seems that all Macros/VBA are enabled. I want Excel to prompt me to enable Macros like it did before.
Some notes:
Things I have tried:
Thoughts? I want Excel to prompt me to enable Macros, as it's a potential security issue.
Some notes:
- Using Excel 2010.
- VBA editor is NOT open when I open the file.
- In the trust center, in Macro Settings, it's set to "Disable all Macros with Notification". Which I believe is correct for what I want.
- In the trust center, "Trust access to the VBA project model" is NOT checked.
- In the trust center, in Message Bar, it's set to "Show all messages... if macros have been blocked".
Things I have tried:
- Checking the security and message settings (stated above).
- I tried to "refresh" the notification settings, by: In the trust center, I set it to "Enable all Macros", exited, reloaded and selected "Disable all Macros with Notification".
- I tried loading other spreadsheets with Macros. They behave the same (erroneous) way; no warning is given, and Macros are just enabled.
Thoughts? I want Excel to prompt me to enable Macros, as it's a potential security issue.