XLplus Add-On: Show Hidden Sheets
Whereas Excel limits you to unhide sheets one after another, you can use Show Hidden Sheets to conveniently unhide any number of sheets of a given workbook.
Tip: Use the lower right corner of the Dialog in order to resize it.
Select the workbook to unhide sheets from. Next select whether to unhide Sheets or Charts. Use [Ctrl] to select non-contigeous list entries, use [Shift] to select contigeous entries.
Tip: Click the column header in order to toggle the sort direction of sheets displayed.
Note: This unhides sheets, too, which were hidden using the method xlVeryHidden. Since these sheets normally cannot be made visible using the Excel Build-In functionality you might want to protect your worksheet to reliably prevent visibility. You can use XLplus Add-On Worksheet Protection to do so. Worksheet Protection is part of XLplus Add-On Basic.
Versions:
Ver.: 2.0.22 and Ver.: 3.0.22 recognize and use new constants for hidden and visible sheets introduced with MS Excel 2007.
See also:
XLplus Delete Hyperlinks
XLplus Save All Workbooks
XLplus Close Workbooks
XLplus Delete Worksheets
XLplus Insert Sheets
XLplus Hide Sheets
XLplus Manage Hidden Cells
XLplus Sort Sheets
XLplus View Special Cells
XLplus Number To Text
XLplus Rename Worksheets
XLplus Convert Characters
XLplus Work with Shapes
XLplus Regional Settings
XLplus Set Zoomfactor of Worksheets
XLplus Goto Sheet