Hidden worksheets

Gwatcheater · Apr 17th, 2002, 06:48 AM

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

jimboy · Apr 17th, 2002, 06:51 AM

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

cpod · Apr 17th, 2002, 06:53 AM

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".

Steve Jukes · Apr 17th, 2002, 06:53 AM

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

Iain Lewis · Apr 17th, 2002, 06:54 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 06:48 AM	#1
Gwatcheater 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

Apr 17th, 2002, 06:51 AM	#2
jimboy 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

Apr 17th, 2002, 06:53 AM	#3
cpod 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".

Apr 17th, 2002, 06:53 AM	#4
Steve Jukes 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

Apr 17th, 2002, 06:54 AM	#5
Iain Lewis 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