AX2767
Removing workbook and worksheet protections
Axiom Software applies a variety of workbook and worksheet protections to Axiom files. If you have the appropriate user rights, you can temporarily remove the workbook or worksheet protections using the unprotect options available on the Axiom ribbon.
NOTE: The workbook and worksheet protection toggles are intended to allow users to temporarily remove and then reapply the protection settings of the existing file. If the sheet or file is not already configured on the Control Sheet to enable protection, selecting these options does not change that configuration. If you want to enable protection for a sheet or a file, use the Control Sheet settings.
Remove worksheet protection
If a sheet is protected, you can temporarily unprotect it as follows:
-
On the Axiom tab, in the Advanced group, click Protect > Worksheet to remove the check mark.
NOTE: In systems with installed products, this feature may be located on the Admin tab—either directly on the ribbon or under File Protection.
The sheet can now be edited as desired. If you do not have rights to remove worksheet protection, then this item does not display on the menu.
The sheet protection will be automatically reapplied the next time the file is opened. If you want to reapply it now, click Protect > Worksheet again to toggle the protection back on.
The Control Sheet settings for an Axiom file determine whether protection is enabled for a sheet. Sheet protection is most often applied to plan files / templates, but may also be applied to driver files and reports as needed. Protection is always applied to Control Sheets.
If a workbook is protected, you can temporarily unprotect it as follows:
-
On the Axiom tab, in the Advanced group, click Protect > Workbook to remove the check mark.
NOTE: In systems with installed products, this feature may be located on the Admin tab—either directly on the ribbon or under File Protection.
You can now make structure changes to the workbook, such as unhiding sheets or adding sheets. If you do not have rights to remove workbook protection, then this item does not display on the menu.
The workbook protection will be automatically reapplied the next time the file is opened. If you want to reapply it now, click Protect > Workbook again to toggle the protection back on.
For report files and driver files, the Control Sheet settings determine whether workbook protection is enabled for the file. For plan files, workbook protection is applied automatically.
NOTE: For plan files, any structure changes made to the file should be temporary (such as unhiding the Control Sheet to troubleshoot an Axiom query). If you delete or rename sheets, this may impact Axiom query settings and use of calc method libraries. Structure changes to plan files should be made in the template, not the individual plan files.
Remove all protection
Users with the appropriate permissions can turn off all protections and display controls at once by using the Show Everything button on the Axiom Designer tab.
NOTE: In systems with installed products, this feature may be located on the Admin tab—either directly on the ribbon or under File Protection.
