...
Multiple protection flags can be combined as can be seen in the examples.
There is a general inheritance rule on protection flags. Once you set protection on a book, then all sheets inside the book will inherent the flags from the book.
| Command | Description | 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 n | set 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
|