?
Solved

Microsoft Excel Security Notice

Posted on 2016-07-18
7
Medium Priority
?
107 Views
Last Modified: 2016-08-01
Hello,

I have a customer getting the attached security notice in Excel.  

Would someone advise what that means?  

Also, what are the buttons "trust all from publisher" or "Enable Macros" represents?

If I want to setup a global setting to address this using Active Directory Group policy, do you know which location I should look at?  

Thanks
0
Comment
Question by:nav2567
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 41717643
"I have a customer getting the attached security notice in Excel."

Nothing is attached.
0
 

Author Comment

by:nav2567
ID: 41717673
Sorry, my bad.  

Here you go.
Screen-Shot-2016-07-15-at-7.43.20-AM.png
0
 
LVL 13

Expert Comment

by:Dustin Saunders
ID: 41717731
Have you added the document source to the trusted locations?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 21

Expert Comment

by:Roy Cox
ID: 41717877
If you are sure that the code is safe then choose enable macros, Excel should remember that choice and not ask again.
0
 
LVL 47

Expert Comment

by:Jackie Man
ID: 41718209
If you are sure that the code is safe then choose enable macros, Excel should remember that choice and not ask again

Enable macro is for the current session only and you will be prompted for this security message when you open the file again.
0
 
LVL 47

Accepted Solution

by:
Jackie Man earned 2000 total points
ID: 41718212
You can change the GPO for VBA macro but it is not a good idea as ransomware are spread via VBA macro also and an alert is better.

Plan security settings for VBA macros for Office 2013
https://technet.microsoft.com/en-us/library/ee857085.aspx
0
 
LVL 21

Expert Comment

by:Roy Cox
ID: 41719428
Jackie in the newer version what I stated is correct, I can't remember when it was introduced but it may have been Office 2013.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Had a business requirement to store the mobile number in an environmental variable. This is just a quick article on how this was done.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question