Disabling macros in MS Office

Stevekir

New member
Member
VIP
Local time
10:49 PM
Messages
231
How can I check that these are set to be disabled on Office? I can't find any place for that.

Thanks.
 

My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Gigabyte ATX case with 500 W power supply GZ-M1
OS
Windows 7 Home Premium 64bit
CPU
Intel Pentium Edition G3220 3.0 GHz
Motherboard
Gigabyte Socket 1150 MicroATX Mot Ultra Durable, GA-H81M-S2H
Memory
8 GB DDR3 1600 MHz DIMM
Graphics Card(s)
Not Known
Sound Card
Not known
Monitor(s) Displays
Samsung LS24D590 23.6"
Screen Resolution
1920 x 1080
Hard Drives
256 GB Solid State Drive (C: on which Windows 7 is installed)-
1 TB internal conventional HD (X:)-
Two WD "Elements" " 2TB USB drives as backups
PSU
500 W
Case
Gigabyte ATX case
Cooling
Several fans!
Keyboard
Accuratus 301 USB Compact, white.
Mouse
Microsoft Basic Optical Mouse v2.0, two-button, tethered
Internet Speed
10 to 12 Mb per second
Antivirus
Kaspersky Internet Security 2016, Malwarebytes (paid)
Browser
Firefox (ocassionally Safari)
Other Info
The 256 GB SSD (C:) also has Adobe Photoshop CS6 and InDesign CS6, MS Office, Adobe Lightroom, and other small programs.
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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Assembled Desktop PC
OS
Microsoft Windows 7 Home Premium SP1 64-bit Build 7600
CPU
AMD Athlon 64 X2 5200+ Dual Core CPU @ 2.7 Ghz (Brisbane)
Motherboard
PCChips A13G+ v3.0
Memory
2x2 GB DDR2 PC-5300 (667 Mhz) Kingston ValueRAM
Graphics Card(s)
XFX ATI Radeon HD 4350 GPU (512 MB + 512 MB HM)
Sound Card
Realtek High Definition Audio Driver ALC660 @ MCP61S
Monitor(s) Displays
HP S2031 20" LED HD Widescreen Display Monitor
Screen Resolution
1600 x 900 px
Hard Drives
Maxtor Diamond Max 10 (160 GB, 7200 RPM, SATA-II Hard Disk)
Western Digital Scorpion Blue (250 GB, 5400 RPM, SATA-II External Hard Disk - Personal Data)
Toshiba MQ01ABD050 (500 GB, 5400 RPM, SATA-II External Hard Disk - Software & ISOs)
PSU
Pixxo Transformer 850W 80+ Certification PSU
Case
Compaq 5BW353 Case
Cooling
Many solutions, see other info...
Keyboard
Green Leaf (Mitzu) Standard Keyboard
Mouse
Microsoft USB Lasser Pointing Device
Internet Speed
10 MB
Antivirus
Avast Antivirus Free
Browser
Firefox, Chrome, Internet Explorer
Other Info
Windows Experience Index Result: 3.8 of 7.9.

Cooling solutions:
- AVC @ 2000/5000 RPM Copper Heatpipes (For Athlon 64 X2 6000+ CPU used in an Athlon 64 X2 5200+)
- Rear Fan 80 mm @ 2700 RPM for heat extraction
- Manhatan Chipset Cooler @ 4700/7200 RPM (For nVidia Chipset in MoBo)
- Foxconn @ 2500 RPM (Old Pentium III heatsink fan) in XFX ATI Radeon HD 4350
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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Self built using existing case
OS
Windows 7 Home Premium 64 bit sp1
CPU
Intel i5 3570 3.4Ghz Ivy Bridge SKT 1155 quad core
Motherboard
Gigabyte Z77-HD3 SKT 1155 2xSata 3, 4x USB 3.0
Memory
G-Skill Rip Jaws 16Gb (8x2) DDR3 -1600 PC3 12800 CL 10 red
Graphics Card(s)
Gigabyte NVIDIA GT610 1Gb DDR3 810/1200 PCI-E 2.0 Silent
Sound Card
NVIDIA High Definition & Realtech High Definition Audio
Monitor(s) Displays
2 x Philips 226V4L 16:9 aspect ratio
Screen Resolution
1920 x 1080 HD
Hard Drives
Samsung 840 Pro 256gb SSD, SATA 3.
Hitachi Touro Portable 1tb, USB 3.0 HDD used for image b/ups.
PSU
Corsair VS450
Case
Codeng
Cooling
PSU fan & CPU fan
Keyboard
Logitech
Mouse
Logitech Wireless trackball M570
Internet Speed
Wireless 3G. 3mg down & 550kb up.
Antivirus
Bitdefender Internet Security 2020
Browser
Opera (Current Version) & Firefox
Other Info
MS Office 2013 Pro. Davis weather station software. MGE Nova 600 avr UPS.
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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Gigabyte ATX case with 500 W power supply GZ-M1
OS
Windows 7 Home Premium 64bit
CPU
Intel Pentium Edition G3220 3.0 GHz
Motherboard
Gigabyte Socket 1150 MicroATX Mot Ultra Durable, GA-H81M-S2H
Memory
8 GB DDR3 1600 MHz DIMM
Graphics Card(s)
Not Known
Sound Card
Not known
Monitor(s) Displays
Samsung LS24D590 23.6"
Screen Resolution
1920 x 1080
Hard Drives
256 GB Solid State Drive (C: on which Windows 7 is installed)-
1 TB internal conventional HD (X:)-
Two WD "Elements" " 2TB USB drives as backups
PSU
500 W
Case
Gigabyte ATX case
Cooling
Several fans!
Keyboard
Accuratus 301 USB Compact, white.
Mouse
Microsoft Basic Optical Mouse v2.0, two-button, tethered
Internet Speed
10 to 12 Mb per second
Antivirus
Kaspersky Internet Security 2016, Malwarebytes (paid)
Browser
Firefox (ocassionally Safari)
Other Info
The 256 GB SSD (C:) also has Adobe Photoshop CS6 and InDesign CS6, MS Office, Adobe Lightroom, and other small programs.
Back
Top