Solved

Keyboard shortcut for showing/hiding Excel worksheet tabs

Posted on 2013-12-29
4
3,659 Views
Last Modified: 2014-01-15
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
Comment
Question by:Steve_Brady
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 19

Assisted Solution

by:Raheman M. Abdul
Raheman M. Abdul earned 250 total points
ID: 39745235
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
 
LVL 9

Expert Comment

by:dexterrajesh
ID: 39745574
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
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 39745707
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
 

Author Closing Comment

by:Steve_Brady
ID: 39784258
Great help. Thanks.
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question