Navigation:  Security > Locking Cells in a User Overhead Sheet (Administrators only)

Any cell can be locked to prevent any change outside the administrator's edit mode.

To lock a cell:

1.Select the cell

2.Swich to Edit mode (refer to Actions)

3.Edit the cell as desired

4.Select Home>Format Cells and check the box Locked, OR directly select the toggler Lock Cell; this changes the icon in the menu item Lock Cell (the padlock is encircled by colored hairline (locked)/crossed out (unlocked))

 

NOTES

- When the Lock Cell menu item is grayed out, the Protection tab is not visible in the Format Cells window

- The icon in the Lock Cell menu item is meaningless when the menu item is grayed out

- If the message "The sheet must be unprotected" pops up unduly when trying to access Formats Cells, it may be due to a recent editability change; to resolve this, save the estimate.

 

As an administrator, handle a new overhead user sheet as follows:

1.Insert a user sheet; this opens the sheet in Edit mode and its cells are locked

2.Edit them

3.Unlock the cells that can be edited by the users

4.Select Administration>Permissions and make the sheet editable for the targeted users group.

NOTES

- For the administrator, the cells are locked only after selecting another tab.

- The step #4 governs only the capacity to switch to Edit mode, hence the right to Edit in Excel AND add an editable sheet therein. This is of interest to users that are not administrator.

 

To put a formula in a cell:

1.Type the formula

2.Select Home>Format Cells and check the boxes Hidden and Locked; the formula bar if any (refer to How to Build a Sheet) is empty.

NOTE Not checking Locked poses the risk of deleting the formula in a try to edit it.