Is there a shortcut to show/hide sheet tabs in Excel?

[svendiamond]

The reason I ask is because a user of one of my workbooks called me and said he could no longer see the sheet tabs. I simply went to Options and checked the box for "Show Sheet Tabs" but I was wondering how he hid them. I know he didn't go to the Options and un-check that box... so is there any kind of shortcut that would toggle this feature? I Googled but couldn't find anything.

 

[63falcondude]

ALT + O + H + H can hide a worksheet

 

[svendiamond]

Thank you for response. I am talking about the option to "Display sheet tabs" -- not actually hiding or unhiding sheets. This option allows you to choose whether or not sheet tabs are shown in your workbook. Wondering if there is a shortcut or other way to do this, besides going into the options menu.

 

[B___P]

Hi svendiamond,

this little code hides or unhides tabs

Sub Hide_Unhide_Tabs()
ActiveWindow.DisplayWorkbookTabs = Not ActiveWindow.DisplayWorkbookTabs
End Sub

Hope this helps

 

[Kyle Bischoff]

Hi svendiamond,

this little code hides or unhides tabs

Sub Hide_Unhide_Tabs()
ActiveWindow.DisplayWorkbookTabs = Not ActiveWindow.DisplayWorkbookTabs
End Sub

Hope this helps

I love you ....

 

[Peter_SSs]

so is there any kind of shortcut that would toggle this feature?

There is a keyboard method, but I'm not sure that I would call it a shortcut and certainly nothing that would have been done accidentally!

Alt+F T AD Alt+BB Space Enter