Only choose this setting if you're certain that you won't be opening any malicious or dangerous files. (b) If the macros are enabled by policy, the macros are enabled. Caution: This will allow ALL macros, both good and bad, to run without any further warning. Other Excel workbooks operate as they should. I clicked on the wrong thing opening an Excel workbook, which seems to have permanently enabled macros for that particular workbook, without giving me the option to disable or enable.
We also tried temporarily disabling virus and firewall protection and making multiple copies of the spreadsheet etc. To allow all macros to run select the Enable all macros radio button. Enable/Disable Macros in one particular Excel Workbook 2010.
We tried to reboot the PC and on each attempt, we've gone into Trust center prior to the next attempt, each time confirming that indeed Macros and VBA are enabled. Excel refuses to open or run the spreadsheet. Macros are Disabled and need to be enabled. You must then select Macro from this drop-down menu (note: If you don’t see this option at first, click the double arrow pointing down at the bottom of the drop-down menu. This makes sense because why would this version of Excel offer VBA and MACRO Trust Center options otherwise?ĭespite the fact that VBA and MACROS are ENABLED in the Trust Center settings, and this was triple verified, when we run the spreadsheet an error dialog pops up saying that In order to change the security settings to allow macros to run in Excel, you must first go to the Tools menu, located at the top of the Excel window. (Option 3) To automatically enable macros on. Then select 'Enable this content.' In Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Excel for Microsoft 365 click the button that says 'Enable Content.' See option 3 below for a different solution using trusted locations. I've been assured by multiple MS support folks and ASK department that Excel from Office 365 is effectively Excel 2013 and In Excel 2007, click the Options button next to this warning message.
This spreadsheet runs perfectly in Excel 2007, 20 on a varierty of PCs with Windows 7 and Windows 8.x. We're trying to run a spreadsheet with MACROS and VBA in the Office 365 version of Excel on WIndows v8.1.