Intune: Microsoft Office
TMA-INTUNE-OFFICE-2.2.4.7.4
Ensure 'Scan encrypted macros in Excel Open XML workbooks' is set to 'Enabled: Scan encrypted macros (default)'
Description
This policy setting controls whether encrypted macros in Open XML documents are required to be scanned with anti-virus software before being opened. The recommended state for this setting is: Enabled: Scan encrypted macros (default). Audit: reads the registry value(s) excelbypassencryptedmacroscan that the Intune policy writes for every loaded user profile (HKEY_USERS) and prints compliant only when each satisfies the benchmark value.
How it is checked
Audit method: Windows registry
$bad = @(); $bad += @(Get-ChildItem Registry::HKEY_USERS | Where-Object { $_.PSChildName -match '^S-1-5-21-\d+-\d+-\d+-\d+$' } | ForEach-Object { $v = (Get-ItemProperty -Path ('Registry::HKEY_USERS\' + $_.PSChildName + '\SOFTWARE\Policies\Microsoft\office\16.0\excel\security') -Name 'excelbypassencryptedmacroscan' -ErrorAction SilentlyContinue).'excelbypassencryptedmacroscan'; if (-not ($null -ne $v -and @(0) -contains [int64]$v)) { $_.PSChildName + ':excelbypassencryptedmacroscan=' + $v } }); if ($bad.Count -eq 0) { 'compliant' } else { 'non-compliant: ' + ($bad -join ', ') }- Expected output
compliant
How it is fixed
Fix method: Guidance or infrastructure patch
To establish the recommended state via configuration profiles, set the following Settings Catalog path to Enabled: Scan encrypted macros (default). Microsoft Excel 2016\Excel Options\Security\Scan Encrypted Macros in Excel Open XML Workbooks
Properties
- Operating systems
- Any
- Tags
- intune-officeintuneregistry
- Reference
- CIS Microsoft Intune for Office Benchmark v1.1.0 - 2.2.4.7.4 Ensure 'Scan encrypted macros in Excel Open XML workbooks' is set to 'Enabled: Scan encrypted macros (default)'
Check this host
Run this on a machine you are allowed to audit. The scan is read-only.
tmaegis scan --target intune-office