Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5213
  • Last Modified:

Keyboard shortcut for showing/hiding Excel worksheet tabs

Hello,

Does anyone know of a keyboard shortcut for showing/hiding Excel 2013 sheet tabs?
If not, does a menu or QAT shortcut exist for doing that?

The only place I can find to show or hide sheet tabs is:

File > Options > Advanced > Display options for this workbook > Show sheet tabs

Thanks
0
Steve_Brady
Asked:
Steve_Brady
2 Solutions
 
Raheman M. AbdulCommented:
save the following in a macro:
--------------------------------------
Sub HideSheetTabs()
ActiveWindow.DisplayWorkbookTabs = False
End Sub

Sub ShowSheetTabs()
ActiveWindow.DisplayWorkbookTabs = True
End Sub

-----------------------------------

QAT dropdown -> More Commands, then choose Macros.
Select ThisWorkbook.ShowSheetTabs and click Add -> OK
Select ThisWorkbook.HideSheetTabs and click Add -> OK

You can click on Modify to change the icon of the buttons.

Click the buttons to test (show or hide).
ShowHideWorksheetTabs.xlsm
0
 
dexterrajeshCommented:
short-cut keys:

Alt+F+T and then under advance Alt+B to enable\disable the sheet tabs

through VBA Macro:

The following two simple VBA codes also can help you to hide or show the sheet tabs.

1. Click Developer > Visual Basic, and a new Microsoft Visual Basic for applications window will display, click Insert > Module, and then input the following codes in the module.

VBA code to hide sheet tabs:

Sub Macro()
ActiveWindow.DisplayWorkbookTabs = False
End Sub

VBA code to show sheet tabs:

Sub Macro()
ActiveWindow.DisplayWorkbookTabs = True
End Sub

hope this helps
0
 
Rory ArchibaldCommented:
I would use one macro that simply toggles the tabs on and off:

Sub ShowHideTabs()
With ActiveWindow
   .DisplayWorkbookTabs = Not .DisplayWorkbookTabs
End With
End Sub

Open in new window

0
 
Steve_BradyAuthor Commented:
Great help. Thanks.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now