Block macros in Microsoft Office suite using registry

block-macro-ms-office.txt

Block Macro in Microsoft office using Windows registry keys
============================================================
(ref - https://www.slipstick.com/outlook/block-macros-office-20132016/)
Office 2016
------------
HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\office\16.0\word\security
HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\office\16.0\excel\security
HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\office\16.0\powerpoint\security

In each key listed above, create this value:
DWORD: blockcontentexecutionfrominternet
Value = 1

Office 2013
-----------
HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\office\15.0\word\security
HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\office\15.0\excel\security
HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\office\15.0\powerpoint\security

In each key listed above, create this value:
DWORD: blockcontentexecutionfrominternet
Value = 1

Office 2010
-------------
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\14.0\msproject\security

In each key listed above, create this value:
DWORD: VBAWarnings
Value = 2

Value 1: Enable All macros
Value 2: Disable all macros with notification
Value 3: Disable all macros except those digitally signed
Value 4: Disable all without notification


* How to get MS Office version information?

Make use of windows management for instrumentation query.
c:\Users\joshi> wmic product where "Name like '%Office%'" get name,version

Another way using powershell is explained here - https://www.drivereasy.com/knowledge/generate-list-installed-programs-windows/