Can Excel VBA Editor Show Only XLSM Files or Selected Objects?
Question details
The user wants to know if the Excel VBA Editor can be configured to display only macro-enabled (.xlsm) files or to hide specific workbook objects.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Managing multiple open workbooks and navigating the VBA Project Explorer without unnecessary clutter.
- Observed behavior
- The VBA Editor automatically loads and displays all projects, worksheets, and objects for all currently open workbooks, and there appears to be no built-in setting to filter the view.
Before organizing your VBA environment, save any active code changes in your macro-enabled workbooks to prevent accidental data loss while managing your open files.
Collapse Unwanted Workbooks in the Project Explorer
While you cannot completely hide open workbooks or filter by file type, you can collapse them to keep your Project Explorer organized and easier to navigate.
Excel's Visual Basic for Applications (VBA) editor is designed to automatically load the object models for all currently open workbooks. Because of this architectural design, it cannot be configured to completely hide specific workbooks or only show .xlsm files.
The best workaround is to manually collapse the projects you do not need to interact with. This keeps the interface clean and minimizes distraction.
Press the 'Alt + F11' shortcut keys on your keyboard to launch the Visual Basic Editor in Excel.
Look for the Project Explorer pane on the left side of the window. If it is not visible, press 'Ctrl + R' or click 'View' > 'Project Explorer' from the top menu.
Click the minus (-) icon next to the name of any open workbook you want to hide the details for. Repeat this for all non-XLSM workbooks so only their project names remain visible.

Try WPS Office for a Lightweight Spreadsheet Experience
If you frequently work with complex data and find your current spreadsheet software sluggish when handling multiple files, WPS Office offers a free, highly compatible, and lightweight alternative. It fully supports Microsoft Excel file formats, including macro-enabled workbooks (.xlsm), ensuring a seamless transition without changing your workflow.
- 1. Download and Install: Download WPS Office Free from the official website and follow the installation wizard.
- 2. Open WPS Spreadsheets: Launch the WPS Spreadsheets module and click 'Open' to browse your local files.
- 3. Load your XLSM Files: Select your existing .xlsm files to open, view, and edit your data seamlessly within WPS.

Frequently Asked Questions
How do I open the VBA Project Explorer if it is hidden?
In the VBA Editor, you can open the Project Explorer pane by pressing 'Ctrl + R' on your keyboard, or by clicking the 'View' tab on the top menu and selecting 'Project Explorer'.
Can I disable macros for specific workbooks while editing others?
You cannot disable macros on a per-workbook basis while they are open in the same instance of Excel. However, you can choose to open specific workbooks in a completely separate Excel instance to isolate their environments.
Why does my VBA Editor run slowly when multiple workbooks are open?
Excel VBA automatically loads the entire object model (projects, worksheets, modules) for all open workbooks. Having many files open consumes significant memory. Closing the VBA Editor before opening heavy workbooks and reopening it later can help mitigate these slowdowns.




