Forum Discussion
Neatwork
May 11, 2023Copper Contributor
Creating a workbook that is protected and viewable
I'm trying to create an excel work book that is viewable by anyone that wants to look at it, but still password protected so only a few people can edit it. I've set up a password, but those that don'...
- May 11, 2023
Press F12 to activate the Save As dialog.
Click the Tools drop down to the left of the Save button and select General Options...
In the resulting dialog, leave the Password to open box empty, and enter a password in the Password to modify box, then click OK. You'll have to enter the password again as confirmation.
Finally, save the workbook.
HansVogelaar
May 11, 2023MVP
Press F12 to activate the Save As dialog.
Click the Tools drop down to the left of the Save button and select General Options...
In the resulting dialog, leave the Password to open box empty, and enter a password in the Password to modify box, then click OK. You'll have to enter the password again as confirmation.
Finally, save the workbook.
Neatwork
May 17, 2023Copper Contributor