get back the security warning to show enable contents
I was getting a message in Excel 2016 "security warning: all Macros have been disable-Enable contents.
I looked up some info on how to enable this document always.I went to security warning area section from file then clicked enable contents. Then I clicked on enable all contents. The section below is advanced which allows only for this session which I did not choose.
My question is how do I get back that warning message because I am scared by what I just did I had enabled Macros which can potentially harm my PC??
I looked up some info on how to enable this document always.I went to security warning area section from file then clicked enable contents. Then I clicked on enable all contents. The section below is advanced which allows only for this session which I did not choose.
My question is how do I get back that warning message because I am scared by what I just did I had enabled Macros which can potentially harm my PC??
Another thing you may want to check is that you haven't inadvertently disabled Security Warnings. See this page for step by step instructions.
https://support.office.com/en-us/article/Enable-or-disable-security-alerts-on-the-Message-Bar-adbf15d9-9195-4498-bdc3-5cb0dfe93852
Hope that helps.
https://support.office.com/en-us/article/Enable-or-disable-security-alerts-on-the-Message-Bar-adbf15d9-9195-4498-bdc3-5cb0dfe93852
Hope that helps.
ASKER
Andrew
I have everything checked off as you had stated but when I open the Excel document the message bar(security warning) does not come up anymore . I believe what I had done according to the info I got from Microsoft article I had made this Excel document trusted by enabling contents for all the time and make document trusted.
I have everything checked off as you had stated but when I open the Excel document the message bar(security warning) does not come up anymore . I believe what I had done according to the info I got from Microsoft article I had made this Excel document trusted by enabling contents for all the time and make document trusted.
ASKER
andrew
Can you please tell me if I have the same exact thing as you suggested checked off. Why doesn't the security warning do not show up? am I ok based on your previous suggestion? I just wanted to know for my own self how do I get the message security warning . What needs to be turned of or checked so that I know for future reference?
Big thanks
Can you please tell me if I have the same exact thing as you suggested checked off. Why doesn't the security warning do not show up? am I ok based on your previous suggestion? I just wanted to know for my own self how do I get the message security warning . What needs to be turned of or checked so that I know for future reference?
Big thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delay Andrew. I Will have to look and see where that article is ? I seldom download excel from the internet. But I just wanted to see always the reversal steps to go back the starting point for my own self. I guess I will not be able to see that security warning.
Thank you
Thank you
Just ensure Macro security is set back to defaults.
1. Open Excel and Click the Developer Tab
2. Click "Macro Security"
3. In Macro Settings, ensure "Disable all macros with notification" is selected. This is Excel's default.
4. Click OK
Done.
Hope that's helpful.