Macro error

[Luigi802]

My macros are enabled and working fine, but everytime I open the formulas or data tab for the first time I get this message "because of your security settings macros have been disabled. to run macros, you need to reopen this workbook, and then choose to enable macros, for more information about enabling macros, click help"

No matter what I do, I can't seem to make it go away, I even totally uninstalled/reinstalled Office

 

[richardtims]

I am using Excel 2016. In 2016, you go to File --> Options --> Trust Center -->Trust Center Settings --> And under the Macro Settings, click "Enable All Macros (not recommended;patentially dangerous code can run)". This should fix your issue. Is this what you have already done? Also, its it a work computer that might have administrative properties that disable this setting?

 

[Luigi802]

I am using Excel 2016. In 2016, you go to File --> Options --> Trust Center -->Trust Center Settings --> And under the Macro Settings, click "Enable All Macros (not recommended;patentially dangerous code can run)". This should fix your issue. Is this what you have already done? Also, its it a work computer that might have administrative properties that disable this setting?

That was the first thing I tried, and yes it is a work Pc, but I have Admin rights to it, so nothing in Excel is disabled and that option is checked

 

[richardtims]

See if this article helps you at all:

https://social.msdn.microsoft.com/F...to-enable-macros-in-excel-2010?forum=exceldev