AX2292

Configuring workbook protection for Axiom files

Workbook protection is configured differently for different types of files.

• Templates / plan files: Workbook protection is always applied to plan files, regardless of the Control Sheet setting. However, templates are not protected so that template authors can configure the workbook as needed.

• All other Axiom files: You can configure a file to be protected by enabling the Workbook Protection On/Off setting on the Control Sheet. The protection is applied when the file is opened.

NOTE: If you want protection to be applied when a snapshot copy is taken of the file, remember to also set Workbook Protection On/Off during snapshot to On. This applies to all files, including plan files.

Workbook protection is applied using a system password. This is intended to block casual users from unhiding sheets, adding or removing sheets, or renaming sheets using standard Microsoft Excel functionality. Only administrators and users with the global Remove Protection permission or the file-specific Allow Unprotect permission can unprotect the workbook using Axiom Software functionality.

If a user unprotects the workbook during a session, the protection settings are reapplied the next time the file is opened.

Microsoft Excel's workbook protection feature allows protection for structure and windows. Axiom files use the default Structure protection only.

IMPORTANT: All clients should keep in mind that workbook and worksheet protection are not substitutes for security. Workbook and worksheet protection are useful for many things—such as hiding setup information in a file and focusing end user input and attention to designated areas—but these protections are not meant to prevent user access to protected areas, they are only meant to discourage access. If a workbook contains any data that a particular user should not be able to see, then that user should not have security permission to access that workbook.