Get Security warning Macros have been disabled in Microsoft Office 2010

Asked By 30 points N/A Posted on -
qa-featured

Hi,

Microsoft Office 2010 is showing a security warning while opening a custom built office template in respect of Microsoft Word, Excel and Microsoft PowerPoint. This is really an awful security warning.
 
However, it does not create other problems after click on Close.
 
Have you any idea for the warning?
 
Please help.
 
Thanks in advance.
 
Security warning Macros have been disabled.
 
Security warning
Macros have been disabled.
SHARE
Answered By 5 points N/A #146167

Get Security warning Macros have been disabled in Microsoft Office 2010

qa-featured

If Macros have been disabled in your Office, this is to get rid of the vulnerable code the Macros has. The Macros security has been added to remind the user of the Macro viruses. But most of the time, we need to enable it to finish our work. We used Macro to communicate with Excel. You can set to enable all Macros in the Trust Center Settings. When you are using Excel, just click the File menu.

Macros in Excel

Click the Option tab at the bottom of the File option.

Prepare for sharing

A new window will appear, select the Trust Center tab on the left pane and then click Trust Center Settings under the Microsoft Excel Trust Center and click OK.

Excel settings - trust center settings

Under the Macro Settings tab, tick the Enable all macros and click OK. You have just set to enable all Macros.

Related Questions