• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 76
  • Last Modified:

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??
0
Basem Khawaja
Asked:
Basem Khawaja
  • 3
  • 3
1 Solution
 
Andrew LeniartSenior EditorCommented:
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 LeniartSenior EditorCommented:
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
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 LeniartSenior EditorCommented:
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now