'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel New Window Disabled by IRM Change Permissions
Question details
Users with Change permission cannot use the New Window feature in an IRM-protected Excel workbook, and VBA macros return runtime error 1004.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to open a new window manually or run the VBA ActiveWindow.NewWindow command in an IRM-protected Excel workbook.
- Observed behavior
- The New Window button is disabled for users with Change access (but works for Full Control), and executing the VBA command results in runtime error 1004.
Ensure you have the exact IRM permission levels assigned to the affected users and document the specific Excel version being used before troubleshooting or escalating the issue.
Escalate to Microsoft Support via Microsoft 365 Admin Center
Since this behavior may be an intentional IRM restriction or a product bug, creating a service request with Microsoft is the most effective path to resolution.
Microsoft Information Rights Management (IRM) is deeply integrated into the Office suite. When certain features like 'New Window' are disabled for specific permission levels, it is often a backend policy behavior that requires administrative review or Microsoft engineering intervention.
Have a user with global or support admin privileges sign in to the Microsoft 365 Admin Center.
On the left-hand navigation menu, click on 'Support' and then select 'New service request'.
Detail the IRM permissions involved, specify that users with 'Change' access are affected while 'Full Control' users are not, mention runtime error 1004 from VBA, and include the exact Excel version.
Temporarily Upgrade User Permissions to Full Control
If opening a new window is critical for immediate work, modifying the user's IRM permission level can serve as a temporary workaround.
Need a Lightweight Alternative to Manage Spreadsheets?
If complex IRM restrictions and recurring runtime errors in Microsoft Excel are disrupting your workflow, consider switching to WPS Office. It provides robust document protection, seamless compatibility with Microsoft Excel formats, and a user-friendly interface without the heavy subscription costs.
- 1. Download and Install: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx files directly without losing any formatting.
- 3. Secure your document: Go to the Review tab to easily set up document passwords and edit permissions tailored to your team's needs.
Frequently Asked Questions
Why does VBA ActiveWindow.NewWindow return Error 1004 in protected workbooks?
Error 1004 often occurs because the Information Rights Management (IRM) permissions restrict the VBA macro from executing commands that require higher privileges. When a user only has 'Change' access, Excel blocks the automated creation of new windows, resulting in this runtime error.
What is the difference between 'Change' and 'Full Control' in Excel IRM?
'Change' allows a user to read, edit, and save changes to the document, but it may restrict structural modifications like opening new views or windows to prevent unauthorized duplication. 'Full Control' grants complete administrative rights, bypassing these viewing and structural limitations.
Can I bypass IRM restrictions to use the New Window feature?
You cannot bypass IRM restrictions without the proper credentials. You must either have the document owner grant you 'Full Control' access, or your administrator must resolve the behavior through a service request with Microsoft Support.
Does WPS Office support Excel's IRM protections?
WPS Office fully supports standard password protection and file encryption for .xlsx files. However, advanced enterprise Microsoft IRM (Information Rights Management) features tied specifically to Azure Active Directory policies may require the original Microsoft ecosystem to fully enforce those specific backend rules.
