Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The instructions in excel's help menu don't work.
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can the bottom tabs in Excel be moved vertically on a worksheet? | Excel Discussion (Misc queries) | |||
How to switch between worksheet tabs on excel via keystroke shortc | Excel Discussion (Misc queries) | |||
Change colour of worksheet tabs in Excel | Excel Discussion (Misc queries) | |||
A "Document Map" of worksheet tabs for Excel | Setting up and Configuration of Excel | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) |