Excel 2010, no security warning to enable macros?

[arooney88]

Hey everyone

So I have my settings for macros set in the trust center to 'disable macros all macros with notification'. When I open up a workbook that needs macros enabled, I'm not seeing the 'security warning' pop up where I can enable them myself?

It used to show up when I opened workbooks and now it isn't and I haven't changed any settings. Is anyone else having this problem? I'm not sure how to fix?

Any help would be great!

 

[MARK858]

See Security Bar in Excel 2010 in the link below. Is that your situation?

http://blog.contextures.com/archives/2012/12/18/excel-2010-runs-macros-without-enabling/

 

[arooney88]

I think this is the issue! Thanks! I would never have thought to check for something like a 'trusted documents' list.

 

[krishnap2w2]

I have encountered a similar problem in excel. I resolved it. I will explain how to handle the enable macros in excel


In Excel, macros are disabled by default for enhanced security. Below are the steps to
Enable Macros in two different versions of Excel:
Excel 2007 Version
Excel 2010 Version