Hi,

Although its true that Read Only (with a password) still allows other users
to modify the worksheet, they can't save it back over the original file. So
in effect the original file is protected from modifications.
If that is good enough, you don't need sheet protection.
But if you use sheet protection remember that it must be turned on for each
sheet.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Terry" wrote:

I have documents on a shared network drive. Is there a way to protect a
workbook from being modified by anyone but me. Read only still gives anyone
the chance to open it and modify it. Save As, Tools, password to modify
still requires a password to open it at all. Others need to view only. Not
edit. Appreciate any help.