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??
Basem KhawajaClinical PharmacistAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew LeniartEE Senior Editor & Independent IT ConsultantCommented:
Hi Basem,

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??

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

Excel Macro Security Default
Done.

Hope that's helpful.
0
Andrew LeniartEE Senior Editor & Independent IT ConsultantCommented:
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.
0
Basem KhawajaClinical PharmacistAuthor Commented:
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.
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Basem KhawajaClinical PharmacistAuthor Commented:
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
0
Andrew LeniartEE Senior Editor & Independent IT ConsultantCommented:
Hi Basem,

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.

Can you provide a link to the Microsoft Article that you followed?

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?

If no macros exist to be blocked, or once a document is declared as safe, then there will be no warning. You should get a warning the first time you open any spreadsheet you download from the Internet and it should default to opening in Protected View Mode.

What needs to be turned of or checked so that I know for future reference?

The two examples I've provided are the default settings for Excel and shouldn't be changed unless you know what you're doing or why you're changing them.  In particular, ensure this is set in Trust Settings.

In Excel, click File > Options > Trust Center > Trust Center Settings

Ensure "Show the Message Bar in all applications when document content is blocked" is checked.

Excel Trust Settings
So long as you have the above set in Excel Options, as well as the settings as shown here, then all is good.

Does that answer your question?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Basem KhawajaClinical PharmacistAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.