VBA & Macro Problems

How to Hide the Tab Strip in an Excel MultiPage UserForm

Kushani Nimanthika Oct 19, 2026 868 views

Question details

The user wants to hide the default tabs on a MultiPage control in a VBA UserForm to implement custom navigation.

How to Hide the Tab Strip in an Excel MultiPage UserForm

Product: Microsoft Excel
Device & OS: not provided
Scenario: Building a custom UserForm where page navigation is handled by hyperlinks or custom command buttons instead of the default MultiPage tabs.
Observed behavior: The default tab strip is visible at the top of the MultiPage control and needs to be removed while keeping the underlying pages active and accessible.

Before you start

Ensure you have the Developer tab enabled in your spreadsheet software and that your macro-enabled workbook is backed up before modifying UserForm properties.

Solution 1Recommended

Modify the Style Property in the VBA Editor

Change the MultiPage control's Style property directly in the VBA Properties window to instantly hide the tabs.

This is the most straightforward method to hide the tabs. By changing the property directly in the designer, you can instantly see the result and design your custom navigation controls around the updated layout.

Open the VBA Editor

Press Alt + F11 on your keyboard to open the Visual Basic for Applications (VBA) Editor.

Open your UserForm

In the Project Explorer pane on the left, locate your UserForm and double-click it to open the designer view.

Select the MultiPage Control

Click once on the MultiPage control inside your UserForm to select it. Ensure the entire MultiPage is selected, not just an individual page.

Change the Style Property

Press F4 to open the Properties window. Scroll down to find the 'Style' property and change its value from '0 - fmTabStyleTabs' to '2 - fmTabStyleNone'.

Modify the Style Property in the VBA Editor

Navigation Maintained: Even though the tabs are hidden, the pages still exist. You can now use VBA code like 'MultiPage1.Value = 1' to navigate between pages using your own custom buttons.

Solution 2

Hide the Tabs Programmatically via VBA Code

Use VBA code to hide the tab strip dynamically when the UserForm initializes.

Create and Manage VBA UserForms Seamlessly in WPS Office

WPS Spreadsheet fully supports VBA macros, allowing you to seamlessly create, edit, and manage UserForms. You can modify MultiPage properties and write custom navigation scripts exactly as you would in Microsoft Excel.

1. Open Developer Tools: Launch WPS Spreadsheet and navigate to the Developer tab on the top ribbon.
2. Access the VBA Editor: Click on 'Visual Basic' to launch the integrated macro editor.
3. Edit MultiPage Properties: Open your UserForm, select your MultiPage control, press F4 to open Properties, and set the Style to '2 - fmTabStyleNone'.

Built-in VBA editor for robust macro developmentHighly compatible with Microsoft Excel (.xlsm) formats and scriptsLightweight, fast performance for heavy data tasksFamiliar user interface with zero learning curve

Frequently Asked Questions

Can I still navigate between pages if the tabs are hidden?

Yes, you can switch pages programmatically using VBA code (e.g., setting MultiPage1.Value = 1 for the second page) triggered by custom command buttons, images, or hyperlinks.

Does hiding the tab strip delete the pages inside the MultiPage control?

No, setting the style to fmTabStyleNone only affects the visual tabs at the top of the control. All pages, their controls, and their contents remain fully intact and accessible via code.

What is the difference between fmTabStyleNone and fmTabStyleTabs?

fmTabStyleTabs (Value 0) is the default setting that displays standard clickable tabs for user navigation. fmTabStyleNone (Value 2) completely hides these tabs, providing a cleaner interface meant for custom-coded navigation.

Why is the Properties window not visible in my VBA Editor?

If the Properties pane is closed, you can easily enable it by pressing F4 on your keyboard, or by clicking 'View' > 'Properties Window' in the top menu of the VBA editor.

Excel & Data Problems