Hi,

Our workgroup recently standardized on a group password. The intent was for
group members to set the group password via tools/options/security, password
to modify, with the "read only recommended" box not checked. However, group
members are setting up passwords every which way, including setting
worksheet-level passwords. Can anyone suggest a macro routine that will open
the worksheet, remove all workhseet level passwords, and set the group
passowrd via tools/options security?

I know the group password, so I'm not looking for a password-cracking
routine; I just want something that will standardize the way we set up our
common password.

Thanks in advance for any help!

David