![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 1
|
How do I hide/un-hide worksheets...
i.e. open a .xls file but cannot see the worksheet tabs at the bottom, even though there are multiple sheets thanks |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Apr 2002
Posts: 2,314
|
If you can't see any sheet names go to Tools/Option/View and click "Sheet Tabs"
to hide and unhide sheets goto: Format/Sheet/Hide or Unhide |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Apr 2002
Posts: 124
|
To hide/unhide worksheets goto Format/Sheet/Hide or Unhide.
If ALL the worksheets tabs are gone then: Tools/Options and put a check in "SheetTabs". |
|
|
|
|
|
#4 |
|
Board Regular
Join Date: Apr 2002
Posts: 83
|
The best way is to set the options to not show worksheets tabs by unticking the box.
Or you can put the following code ActiveWindow.DisplayWorkbookTabs = false in the workbook open event |
|
|
|
|
|
#5 |
|
Board Regular
Join Date: Apr 2002
Location: Midlands, UK
Posts: 217
|
For "Hidden" tabs - Go to the "Tools" menu. Select options. On the "View" tab look in the bottom right hand corner. There is a check box next to "Sheet Tabs". Make sure this bok is checked & the tabs should now be visible.
If you mean that the actual sheet is hidden the go to the "Format" menu, select "Sheet" and then select "unhide". You'll be given a list of sheets that are hidden. Unfortunatley you can only unhide them one sheet at a time. HTH |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|