The company I work for has only partially rolled out Office 2007. So some
users of my worksheets have 2007, some have 2003 and some have both.

I have a set of worksheets in which users track their data. These are
password protected to modify. Now that some users are opening the workbooks
with 2007, I am finding that the workbooks occasionally have the password
removed. I have re-set it several times, but invariably after a week or so,
the password is gone again.

We can't have all users upgraded to 2007 as at least one key user's machine
isn't able to make the transition, and we are waiting for that unit to be
replaced. Also, there are other workbooks used by larger groups, and I don't
always know if they will be using 03 or 07.

Any ideas? Thanks!