Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
magician
 
Posts: n/a
Default How can I find/unhide hidden excel sheet tabs on a worksheet?

The instructions in excel's help menu don't work.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macropod
 
Posts: n/a
Default How can I find/unhide hidden excel sheet tabs on a worksheet?

Hi magician,

In most cases Format|Sheet|Unhide will display a list of hidden worksheets
attached to the workbook. Simply select the one you want to unhide, and
press OK.

If there are any other worksheets, they'll have been hidden with the
'xlveryhidden' property, which you'll need vba to unhide. For example:

Sub ShowAllSheets
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
ws.Visible = True
Next
End Sub

Cheers


"magician" wrote in message
...
The instructions in excel's help menu don't work.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can the bottom tabs in Excel be moved vertically on a worksheet? Laura Excel Discussion (Misc queries) 2 March 9th 06 08:25 PM
How to switch between worksheet tabs on excel via keystroke shortc JohnK Excel Discussion (Misc queries) 2 January 26th 06 03:09 PM
Change colour of worksheet tabs in Excel GlynH Excel Discussion (Misc queries) 5 September 29th 05 11:09 PM
A "Document Map" of worksheet tabs for Excel BCS Setting up and Configuration of Excel 2 June 22nd 05 01:33 PM
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"