Add a Show Sheet Tabs Toggle to the WPS Spreadsheets Quick Access Toolbar
Question details
The user needs a one-click Quick Access Toolbar toggle for showing or hiding sheet tabs because the Advanced Options display setting cannot be added directly.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user wants to quickly show or hide sheet tabs without opening Advanced Options each time, using the Quick Access Toolbar.
- Observed behavior
- The Advanced Options setting for displaying sheet tabs cannot be added directly to the Quick Access Toolbar.
Make sure the Developer tab is visible and that macros are enabled in WPS Spreadsheets, because the Quick Access Toolbar needs an existing macro to add.
Add a ToggleSheetTabs Macro to the Quick Access Toolbar in WPS Spreadsheets
Use this method when you want a one-click button in the Quick Access Toolbar that shows or hides sheet tabs without opening the Advanced Options dialog every time.
The ActiveWindow.DisplayWorkbookTabs property controls sheet tabs for the current workbook window. By setting it to the opposite of its current value, the same QAT button serves as an on/off toggle.
In WPS Spreadsheets, open the workbook and press Alt+F11 to open the VBA editor. If the Developer tab is hidden, enable it from Options > Customize Ribbon first.
In the VBA editor, click Insert > Module, then paste the following macro: Sub ToggleSheetTabs() : ActiveWindow.DisplayWorkbookTabs = Not ActiveWindow.DisplayWorkbookTabs : End Sub.
Press Ctrl+S or click File > Save, then close the VBA editor. Save the workbook in a macro-enabled format such as .xlsm if prompted.
Click the Quick Access Toolbar drop-down arrow, choose More Commands, select Macros from the Choose commands from list, select ToggleSheetTabs, click Add, and press OK.
Click the new Quick Access Toolbar button to toggle sheet tabs on and off for the active workbook window.
Toggle Sheet Tabs in WPS Spreadsheets with the Quick Access Toolbar
Use a small VBA macro in WPS Spreadsheets to create a one-click sheet tab toggle on the Quick Access Toolbar. This gives you Excel-compatible macro customization without switching tools.
- 1. Open WPS Spreadsheets and enable macros: Launch WPS Office, open WPS Spreadsheets, and go to the Developer tab or Options > Macro Security to allow macros before adding the VBA code.
- 2. Create the ToggleSheetTabs macro: Press Alt+F11, click Insert > Module, and paste: Sub ToggleSheetTabs() : ActiveWindow.DisplayWorkbookTabs = Not ActiveWindow.DisplayWorkbookTabs : End Sub.
- 3. Add the macro to the Quick Access Toolbar: Click the Quick Access Toolbar drop-down arrow, choose More Commands, select Macros, add ToggleSheetTabs, and click OK.
- 4. Save as a macro-enabled workbook: Save the file as .xlsm so the toggle remains available the next time you open the workbook.
Frequently Asked Questions
Why can't I add the Show Sheet Tabs option directly to the Quick Access Toolbar?
The Advanced Options display setting is not exposed as an individual command, so you need a VBA macro that calls ActiveWindow.DisplayWorkbookTabs.
Does this macro work in Excel and WPS Spreadsheets?
Yes, the VBA property is compatible in both applications, but you must save the workbook in a macro-enabled format such as .xlsm.
How do I enable macros if the button does not run?
Open WPS Spreadsheets, go to Options or Macro Security, allow macros, and reopen the workbook.
Can I remove the toggle from the Quick Access Toolbar later?
Yes, open Quick Access Toolbar customization, select the macro in the right pane, and click Remove.
What file format should I save to keep the macro?
Save as .xlsm or .xlam. The .xlsx format does not retain VBA macros.
