Forum Discussion
How to password protect document but allow read only if you do not have password
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)
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
