VBA & Macro Problems

Can Excel VBA Editor Show Only XLSM Files or Selected Objects?

Maira MehtabMaira Mehtab Nov 4, 2026 868 views

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.

Can Excel VBA Editor Show Only XLSM Files or Selected 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 you start

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.

Solution 1Recommended

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.

1
Open the VBA Editor

Press the 'Alt + F11' shortcut keys on your keyboard to launch the Visual Basic Editor in Excel.

2
Locate the Project Explorer

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.

3
Collapse the Workbooks

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.

Collapse Unwanted Workbooks in the Project Explorer
Performance Tip: If your VBA Editor is running slowly due to many open workbooks, try closing the VBA editor before opening a new heavy workbook, and reopen it afterward. This can help improve memory allocation and performance.
Free Microsoft Office alternative

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. 1. Download and Install: Download WPS Office Free from the official website and follow the installation wizard.
  2. 2. Open WPS Spreadsheets: Launch the WPS Spreadsheets module and click 'Open' to browse your local files.
  3. 3. Load your XLSM Files: Select your existing .xlsm files to open, view, and edit your data seamlessly within WPS.
Fully compatible with Microsoft Excel formats, including .xls, .xlsx, and .xlsm files.Lightweight architecture ensures smooth performance even with multiple open files.Familiar user interface requires no learning curve for Excel users.Robust data analysis capabilities packed into a free software suite.
microsoft office alternative - wps office

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.