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,