Open in the explorer

Store macro in Personal Macro Workbook by default

Type
User
GPO path
User Configuration › Policies › Administrative Templates › Microsoft Excel 2016 › Excel Options › Security › Trust Center
Supported on
At least Windows Server 2008 R2 or Windows 7
ADMX file
excel16.admx
Internal name
excel16/L_StoremacroinPersonalMacroWorkbookbydefault

Explanation

This policy setting controls the default location for storing macros in Excel.

If this policy setting is enabled, Excel stores macros in users' personal macro workbook.

If you disable or do not configure this policy setting, Excel stores macros in the active workbook from which they are created.

Note: In the user interface (UI), the "Store macro in" drop down list box in the Record Macro dialog box (Macros | Record Macro) allows users to choose whether to store the new macro in the current workbook, a new workbook, or their personal macro workbook (Personal.xlsb), a hidden workbook that opens every time Excel starts.

By default, Excel displays the "Store macro in" box with "This Workbook" already selected in the drop-down list. If a user saves a macro in the active workbook and then distributes the workbook to others, the macro is distributed along with the workbook. If you enable this policy setting, Excel displays the "Store macro in" box with "Personal Macro Workbook" already selected. Users can still select one of the other two options in the drop-down menu.

Registry

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options\binaryoptions
Value name
fglobalsheet_37_1
StateValue written
EnabledREG_DWORD = 1
DisabledREG_DWORD = 0

PowerShell

PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.

Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.

Enable

# Enable: excel16/L_StoremacroinPersonalMacroWorkbookbydefault
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'fglobalsheet_37_1' -Value 1 -Type DWord

Disable

# Disable: excel16/L_StoremacroinPersonalMacroWorkbookbydefault
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'fglobalsheet_37_1' -Value 0 -Type DWord

Revert to "Not configured"

# Revert to "Not configured": excel16/L_StoremacroinPersonalMacroWorkbookbydefault
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
Remove-ItemProperty -Path $k -Name 'fglobalsheet_37_1' -ErrorAction SilentlyContinue

Application

Microsoft 365 Apps / Office (Microsoft) — November 2026 templates

Official templates downloaded on November 12, 2026.