Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Disabling macros in MS Office

22 Dec 2015   #1

Windows 7 Home Premium 64bit
Disabling macros in MS Office

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


My System SpecsSystem Spec
22 Dec 2015   #2

Microsoft Windows 7 Home Premium SP1 64-bit Build 7600 / Microsoft Windows XP Professional SP3

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.
My System SpecsSystem Spec
22 Dec 2015   #3

Windows 7 Home Premium 64 bit sp1

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.
My System SpecsSystem Spec

24 Dec 2015   #4

Windows 7 Home Premium 64bit

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").
My System SpecsSystem Spec

 Disabling macros in MS Office

Thread Tools

Similar help and support threads
Thread Forum
Hi, I am trying to use macro enabled spreadsheet Excel 2010 on a WIN 7 O/S and am getting the error that 'Cannot run the maco 'Goodexcel2CI.xlsm!submitDataToDatabaseMacro'.The Macro may not be available in this workbook or all macros may be disabled. If anyone could give me some...
General Discussion
disabling automatic formatting Microsoft Office 2010
I have followed the directions for disabling automatic bulleting in Microsoft Office 2010 by highlighting NONE on each of the menus for parapraphing options. But I still have automatic bulleting every time I start a new paragraph. I can get rid of this sometimes by clicking on NORMAL for the...
Microsoft Office
Can I Create Macros on Windows 7
Windows 7 has recently been loaded on my laptop. Can Windows 7 create macros that will open windows or websites? Thank you.
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 21:52.
Twitter Facebook