Disabling macros in MS Office

Stevekir · 22 Dec 2015

How can I check that these are set to be disabled on Office? I can't find any place for that.

Thanks.

FerchogtX · 22 Dec 2015

Go to your office Options (any Office program will do, as long as you access the options window), go to "Trust Center" -> Trust Center Settings, and there, check if they are disabled, by default, Office 2010-2016 disable macros by default.

Ranger4 · 22 Dec 2015

Open Excel, select File, then Options, scroll down to Trust Centre, click on that & then select Macro Settings & that will show you some Options. My Office 2013 is set at Disable all Macros with Notification.

I have done the same check on Word & Access & they have the same settings as far as the macros are concerned. You may need to check other Office programs that have Macros, but these ones are the only ones I usually use.

You can make sure you have the latest Update by opening any Office program &, select File, then Account, then Update, click on Update Options & select Update Now. The update can run in the background even if you are actually using Office.

Stevekir · 24 Dec 2015

Thanks to both. I checked and macros were disabled (as expected because I had not changed the defaut).

On the wider issue of keeping Office up to date, News > Security News has a thread which told me how to update Office as a whole, which was very easy. That thread will get buried in time. I have suggested to A Guy that the info he posted in the topic News > Security News, headed "Crooks update their exploits - have you updated your Office? is made into a sticky and put into this topic here ("Microsoft Office").