...
Once you have lock a worksheet from modifications, all the cells in the sheet become read-only. Often it is desirable to setup a sheet as a form, such that only certain cells can be modified to allow user to enter values into. To achieve this, we have added the LabTalk command to add such Exclusion Zones.
| Code Block |
|---|
Layer -LES n |
where n can be of the followings:
| Value | Description |
|---|---|
| 0 | Clear all the Exclusion Zones on the active sheet |
| 1 | Add the current selection, one range or multiple via cntrl-select, to add as new Exclusion Zones |
| 2 | List the Exclusion Zones into the script window |
Please note that you can only make Exclusion Zone modification when the sheet is unprotected. So to set the sheet up as a form, you should first add all the needed Exclusion Zones, then protect the sheet from medication with lay -lw hex(82); for example.
Admin Mode
We have introduced the concept of Admin Mode to the Origin Project, with an Admin password. Once a project is protected by a password, worksheet and workbook protection features can be accessed only after user has logined with the admin password. We have also added LabTalk access to protect books and sheets.
...