 |
 |
|
 |
 |
|
 |
 |
 |
In the spreadsheet module in Synthesis Workbooks, you can protect the contents of a cell from being modified and/or viewed. This protection can be applied to all cells in a sheet or just a few.
The locked and hidden attributes for any cell can be configured in advance and then will be applied only if cell protection is enabled for the spreadsheet. By default, every cell attribute is set to locked and not hidden.
To lock/hide and protect cells, do the following:
If cell protection is already enabled, toggle it off temporarily by right-clicking the sheet tab and choosing Unprotect Sheet.
Select the cell(s) you want to configure. Note that if you want to select the whole sheet, click the Select All button.
Choose Home> Cells > Format > Format Cells. In the window, click the Protection tab.
Specify whether the selected cell(s) will be locked and/or hidden when protection is enabled.
Locked: The cell’s contents are visible in both the cell and data entry bar but cannot be changed. If sheet protection has been enabled and you try to make a change, you an error message.
Hidden: The cell’s contents are visible in the cell but not in the data entry bar. For example, you might choose to use this option if you want to hide a formula. The result is displayed in the cell but the formula in the data entry bar is hidden from view.
While you can use the hidden option by itself, it is more practical to combine it with the locked option to keep the cell's contents from being changed.
In the Protect Sheet window, select the elements that can be changed by any user and enter a password (optional).
© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.
 |
E-mail Link |