...
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. The exception to this rule is Delete, you must separately control book and sheet delete flag, like you may want the book not to allow delete but individual sheet may allow.
Command | Description | Examples |
---|---|---|
| set worksheet write access flags |
|
layer -lt | print out current protection flags | |
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
|
page -lt | print out the current protection flags |
|
...