Worksheet Manager

OAK's Worksheet Manager is a tool for manipulating what can be a large collection of worksheets and charts in a workbook. The Worksheet Manager also deals with macro sheets and dialog sheets.

Protection, Calculation and Visibility

The Worksheet Manager can be used to change the protection, calculation or visibility of a whole selection of sheets in one operation.

Renaming

The Worksheet Manager can be used to perform find and replace operations, including the use of wildcards.

Selection and Ordering

The Worksheet Manager can be used to select groups of sheets based on criteria such as:

•Ordinal position in the workbook

•Sheet type (worksheet chart, macro sheet, dialog)

•Name (with wildcards)

•Protection, calculation and visibility status

The selected sheets can then modified or reordered as a group.