View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dreiding Dreiding is offline
external usenet poster
 
Posts: 80
Default How do you trap the worksheet unprotect?

I needs to detect if a workbook has had any worksheets unprotected.
My expectation is to have a document property set to "unchanged" with
worksheets protected when saved. I then send out the workbook to my
customers. If they unprotect any worksheet, the document property gets set to
"modified". This way I can detect if they potentially modified some of the
equations, etc..

Any suggestions?

Thanks,
- Pat