Store macro in Personal Macro Workbook by default
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
| State | Value written |
|---|---|
| Enabled | REG_DWORD = 1 |
| Disabled | REG_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 DWordDisable
# 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 DWordRevert 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 SilentlyContinueApplication
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.