Protect Worksheets

Overview

If you protect a worksheet in a workbook using Excel's Protect Sheet feature, the Jet Excel add-in will not be able to generate a report.

Using +LOCK

The Jet add-in will automatically protect locked worksheets (worksheets that have Auto+Hide +Lock in cell A1) after a report is generated and will automatically un-protect locked worksheets when the report is returned to Design mode.