Forum Discussion
Setting a password to open or modify a file
Hi, I have excel files that I need some people to be able to edit and others to be ably to read only. I came across this instruction description which sounds like it would work for what I nee...
Maybe these instructions will help you, if not please ignore them, if so, a small feedback with thumbs up would be good.
1. In the Tools menu under Protection, select the command Allow users to edit areas ... (only available if the worksheet is not protected) and click the New ... button.
2. A title is entered in the Title field for the area for which you share access.
3. In the Refers to cells box, type an equal sign (=), then type a reference or select the range.
4. A password for access to the area is entered in the Password of the area. The password is optional; if you do not provide a password, all users can edit the cells.
5. Click Permissions and Add ...
6. Select the users you want to grant access to. To select multiple users, hold down the CTRL key while clicking on the individual names.
7. Confirm with OK and enter the password again when prompted.
Steps 1-7 must be repeated for each area for which you want to grant access.
I would be happy to find out if I could help.
Nikolino
I know I don't know anything (Socrates)
1. In the Tools menu under Protection, select the command Allow users to edit areas ... (only available if the worksheet is not protected) and click the New ... button.
2. A title is entered in the Title field for the area for which you share access.
3. In the Refers to cells box, type an equal sign (=), then type a reference or select the range.
4. A password for access to the area is entered in the Password of the area. The password is optional; if you do not provide a password, all users can edit the cells.
5. Click Permissions and Add ...
6. Select the users you want to grant access to. To select multiple users, hold down the CTRL key while clicking on the individual names.
7. Confirm with OK and enter the password again when prompted.
Steps 1-7 must be repeated for each area for which you want to grant access.
I would be happy to find out if I could help.
Nikolino
I know I don't know anything (Socrates)