Thoughts? I want Excel to prompt me to enable Macros, as it's a potential security issue. They behave the same (erroneous) way no warning is given, and Macros are just enabled. I tried loading other spreadsheets with Macros.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'.Checking the security and message settings (stated above).In the trust center, in Message Bar, it's set to 'Show all messages.In the Record Macro dialog box: After clicking OK, every keystroke is. In the trust center, 'Trust access to the VBA project model' is NOT checked. On the View tab, in the Macros group, click the Macros command.Which I believe is correct for what I want. In the trust center, in Macro Settings, it's set to 'Disable all Macros with Notification'.VBA editor is NOT open when I open the file.I want Excel to prompt me to enable Macros like it did before. It seems that all Macros/VBA are enabled. That message no longer appears when I open the spreadsheet. Though There Are Variations, the Software Is Still the same:-Since I Uninstalled my excel version 2007 a few weeks before, I have been using Excel Version 2010 after that.

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. The message that reads on your screen asking if you need macros to be enabled or disabled with your system is just because of this Visual Basic Editor only. I'm working on a spreadsheet with macros and VBA.

How to enable macro in excel 2010