View Single Post
  #1   Report Post  
West
 
Posts: n/a
Default How do I auto-protect a worksheet?

I have set my w/sheet to "protect" with some cell left "un-protected" for
easy data entry. I want to share my w/sheet and increase it's security level.
Is there a way to set the w/sheet on a "auto-protect" mode so that the file
is "protected" every time I close the file?. Using the manual "protect sheet"
is not so efficient as we tend to forget to "re-protect" it again when we
"unprotect" the w/sheet for maintainance purposes.