I added a password to my spreadsheet by going to "Save As", Tools, General Options and added a password to "Password to modify".

What I am encountering is when someone opens the file in Read Only, it is locking me out from editing.

What I am looking for is when someone opens the file in read only, I can still enter the password to edit.

Any suggestions?

Thank you,