XLplus Add-On: Hide Sheets
Whereas Excel limits you to hide sheets one after another, you can use Hide Sheets to conveniently hide 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 hide sheets from. Next, select whether to hide 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.
Next specify the method to hide sheets:
Sheets hidden by method Very Hidden cannot be made visible again by another user (at least without using some tools).
Note: This method is not a reliable protection for your content. Sheets hidden this way can be made visible using Show Hidden Sheets. To reliably prevent visibility you have to protect your worksheet. You can use XLplus Add-On Worksheet Protection to do so. Worksheet Protection is part of XLplus Add-On Basic.
See also:
XLplus Delete Hyperlinks
XLplus Save All Workbooks
XLplus Close Workbooks
XLplus Delete Worksheets
XLplus Insert Sheets
XLplus Show Hidden 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