Hi David,

To remove the sheet level passwords, see JE McGimpsey at:

http://www.mcgimpsey.com/excel/removepwords.html


---
Regards,
Norman


"DavidH" wrote in message
...
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