View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey
 
Posts: n/a
Default Template becomes Unprotected

#1
Are you sure they are using your template, not a new file they've dummied up
to look just like your template? Compare those modified files to your
template by checking File-Properties and looking to see if the Author is the
same.

#2
If they are using your template, be aware that cracking the protection on a
worksheet is pretty simle. There are utilities that Google can find for you
that will do it.

"Erika" wrote:

I have created an Expense Template for associates to use. All formulas are
protected and some cells are unlocked so they can make entires. Every once
in awhile I get an expense template back and a formula has been modified - I
know that no one knows the password - how can the formulas be changing?