Versions Compared

Key

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

...

Workbook Worksheet Protection Commands

 Multiple You can use the following labtalk commands to look a sheet of a book. If Admin password has not been set, these commands will work fine. Once Admin password is set, then you must login first before using these commands.

Multiple protection flags can be combined as can be seen in the examples.

 

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 0;//remove all the protections on the current sheet

layer -lt print out current protection flags 
page -lw nset workbook write access flags 
 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