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
|
page -lw n | set workbook write access flags | //the following will prepare the book for locking active sheet but allow analysis results added to book lay -lw hex(482);//no del, no add/insert/move col/rows, no edit data
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
|