The Worksheet Manager tab on the Options form provides a number of configuration settings for the Worksheet Manager.
These are Calculation, Sheet Type Indicator and input sheet name defaults.
CALCULATION
The Worksheet Manager gives the user the power to easily change the calculation property of a worksheet. This is potentially dangerous, so a variety of options have been provided to safeguard this operation.
Read Only - User cannot change the property value.
Enable Only - User can only enable the property.
Yes/No prompt - User can change the value, but will be presented with a confirmation when turning calculation off.
SHEET TYPE INDICATOR
The Worksheet Manager enables the user to configure a name that is defined locally on each sheet, to indicate the purpose of that sheet. Excel terminology already includes "Sheet Type" to distinguish worksheets, charts, macro sheets and dialogs.
These settings specify the column titles for these types.
The "Named Type" value is the displayed column title for a sheet type defined in a local name in the sheet.
The "Excel Sheet Type" value is the displayed column title for the Excel sheet type, e.g. Worksheet, Chart, etc.
INSERT SHEET NAME DEFAULTS
These are the default names that will be used when the Worksheet Manager is used to create new sheets. The default name will be suffixed with a number. The original names can be reset by clicking the Reset button on the form.