Forum Discussion
Solved
How to password protect document but allow read only if you do not have password
I would like to password protect my document, but have the option to read only if you do not have the password. If I go to 'Info' and set to password protect and read only, it still makes users enter the password then opt-in to read only. I'm using Office 365 Excel. Other excel sheets in my organization can do this but I can't seem to do it on mine. Maybe their documents used another version of excel when they were created...
Press F12 to activate the Save As dialog.
Click the Tools drop down to the left of the Save button and select 'General Options...'.
Enter a password in the 'Password to modify' box:
After clicking OK, you'll have to re-enter the password as confirmation.
Then save the workbook.
When users open it later on, they'll get this dialog:
They can click 'Read Only' without entering the password (note that the OK button will be disabled as long as the Password box is empty)
2 Replies
Press F12 to activate the Save As dialog.
Click the Tools drop down to the left of the Save button and select 'General Options...'.
Enter a password in the 'Password to modify' box:
After clicking OK, you'll have to re-enter the password as confirmation.
Then save the workbook.
When users open it later on, they'll get this dialog:
They can click 'Read Only' without entering the password (note that the OK button will be disabled as long as the Password box is empty)
- That's it! Thank you so much
