ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a shortcut for unhiding an Excel sheet in a workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/162854-there-shortcut-unhiding-excel-sheet-workbook.html)

Colleen

Is there a shortcut for unhiding an Excel sheet in a workbook?
 


Rick Rothstein \(MVP - VB\)

Is there a shortcut for unhiding an Excel sheet in a workbook?
 
Maybe this... Alt+o+h+u

Rick

Otto Moehrbach

Is there a shortcut for unhiding an Excel sheet in a workbook?
 
You can write a little macro to do that and assign a key stroke combination
to that macro. Of course, the macro will have to know the name of the sheet
you want to unhide and once you put that name in the macro, that macro will
unhide that sheet only. Something like:
Sub HideTwo()
Sheets("Two").Visible = True
End Sub
Note that this macro unhides a sheet named "Two". HTH Otto
"Colleen" wrote in message
...





All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com