| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhide Worksheets
Randy
SUPER! thanks "Randy L" wrote: I performed a search on "unhide multiple worksheets" and found a few responses. You can unhide multiple worksheets using a macro. Gord Dibbon provided the following macro to a user who had the same question: Sub Show_Sheets() Dim i As Integer For i = 1 To ActiveWorkbook.Worksheets.Count ActiveWorkbook.Worksheets(i).Visible = True Next i End Sub HTH "Wanna Learn" wrote: Hi My workbook contains 40 worksheets . I need to unhide 35 of the worksheets. Is there an easier way to unhide worksheets other than one at a time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I hide and unhide worksheets in Excel 2007? | Excel Discussion (Misc queries) | |||
| unhide several worksheets | Excel Discussion (Misc queries) | |||
| How do I unhide several worksheets within a workbook? | Excel Discussion (Misc queries) | |||
| Feature Suggtions: group worksheets within a wbk; unhide many at o | Excel Discussion (Misc queries) | |||
| Unhide Worksheets (hidden via macros) | Excel Discussion (Misc queries) | |||
Linear Mode
