Ensure 'Excel 3 macrosheets and add-in files' is set to 'Enabled: Open/Save blocked, use open policy'

AltaNivel 1Automatizadaoffice

Descripción

This policy setting determines whether users can open, view, edit, or save Excel files with Excel 3 macrosheets file format. Open/Save blocked, use open policy: Both opening and saving of the file type will be blocked. The file will open based on the policy setting configured in the "default file block behavior" key. Rationale: Using legacy file formats could allow malicious code to become active on user computers or the network. User setting: the audit checks HKEY_USERS\<SID>\SOFTWARE\Policies\Microsoft\office\16.0\excel\security\fileblock:xl3macros (REG_DWORD) in every loaded user hive (S-1-5-21-*) and is compliant when each holds 2. It prints 'no-user-hive-loaded' (FAIL) when no user profile is loaded, so scan while users are logged on.

Cómo se verifica

Método de auditoría: Registro de Windows

registry

$sids = @(Get-ChildItem -Path 'Registry::HKEY_USERS' -ErrorAction SilentlyContinue | Where-Object { $_.PSChildName -match '^S-1-5-21-\d+-\d+-\d+-\d+$' } | ForEach-Object { $_.PSChildName }); if ($sids.Count -eq 0) { 'no-user-hive-loaded' } else { $bad = @(); foreach ($s in $sids) { $v = (Get-ItemProperty -Path ('Registry::HKEY_USERS\' + $s + '\SOFTWARE\Policies\Microsoft\office\16.0\excel\security\fileblock') -Name 'xl3macros' -ErrorAction SilentlyContinue).'xl3macros'; if (-not ($null -ne $v -and @(2) -contains [int64]$v)) { $bad += $s + ':xl3macros=' + $v } }; if ($bad.Count -eq 0) { 'compliant' } else { 'non-compliant: ' + ($bad -join ', ') } }

Salida esperada: compliant

Cómo se corrige

Método de corrección: Guía o parche de infraestructura

Configure through Group Policy (User Configuration): User Configuration\Administrative Templates\Microsoft Excel 2016\Excel Options\Security\Trust Center\File Block Settings\Excel 3 Macrosheets and Add-in Files = Enabled: Open/Save blocked, use open policy

Propiedades

Sistemas operativos: Cualquiera
Etiquetas: officeproductivitycis-l1
Referencia: CIS Microsoft Office Enterprise Benchmark v2.0.0 - 2.2.4.7.2.2.5 Ensure 'Excel 3 macrosheets and add-in files' is set to 'Enabled: Open/Save blocked, use open policy'

Verificar este host

Ejecute esto en un equipo que tenga permiso para auditar. El escaneo es de solo lectura.

shell

tmaegis scan --target office