Versions Compared

Old Version 30

changes.mady.by.user Chao P Yang

Saved on

compared with

New Version 31

changes.mady.by.user Chao P Yang

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

CommandDescription          Examples       

layer -lw n

set worksheet write access flags

lay -lw hex(82);//set active sheet to protect data and structure

lay -lw;//protect everything

lay -lw 2;// protect only data

lay -lw hex(180);//no insert/del col/rows, no worksheet rename

lay -lw 0;//remove all the protections on the current sheet

layer -lt print out current protection flags 
page -lw nset workbook write access flags

 //the following will prepare the book for locking active sheet but allow analysis results added to book

lay -lw hex(582);//no del, no rename, no add/insert/move col/rows, no edit

page -lw hex(400);//no del book

 

 page -lt print out the current protection flags

page -lw;//lock book and all sheets, nothing can be change and cannot delete book or sheets

page -lw hex(400);//prevent user deleting the book

page -lw; //lock the book completely, cannot even delete

page -lw hex(482); //lock delete, structure change and data edit

 

Excluding Cells to Allow Entering Values

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.

 

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.

...