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
Stevekir

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.

Thanks.


My System SpecsSystem Spec
.
22 Dec 2015   #2
FerchogtX

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
Ranger4

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
Stevekir

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
Reply

 Disabling macros in MS Office




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Excel Warnings - Macros
I have an Excel Workbook that I use a lot. As far as I know, the workbook doesn't contain any macros but I continue to get this message: C:\Users\AccountName\Documents\Spreadsheet.xls contains macros. Macros may contain viruses. It is always safe to disable macros, but if the macros are...
Microsoft Office
MACROS NOT WORKING IN WIN 7 32 bit O/S
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
Excel Macros Disabled Under W7
Last week, I received a new notebook with Win 7 professional as OS - :o New to me and I feel way behind time noting the posting dates on the forum. Then there is reference to W8 :shock: I have been developing a program in Excel since 1995, improving the macros and output worksheets as I go along....
Microsoft Office


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 05:49.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App