Setting a password to open or modify a file

%3CLINGO-SUB%20id%3D%22lingo-sub-1529517%22%20slang%3D%22en-US%22%3ESetting%20a%20password%20to%20open%20or%20modify%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529517%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20excel%20files%20that%20I%20need%20some%20people%20to%20be%20able%20to%20edit%20and%20others%20to%20be%20ably%20to%20read%20only.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20came%20across%20this%20instruction%20description%20which%20sounds%20like%20it%20would%20work%20for%20what%20I%20need.%20However%2C%20when%20I%20click%20the%20link%20and%20go%20to%20Protect%20an%20Excel%20File%2C%20these%20instructions%20only%20tell%20me%20how%20to%20look%20the%20entire%20access%20to%20the%20file%20with%20a%20password.%20I%20do%20not%20get%20information%20on%20how%20to%20give%20some%20people%20one%20kind%20of%20access%20and%20others%20another%20kind%20of%20access.%20Can%20anyone%20help%20me%3F%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESetting%20a%20password%20to%20open%20or%20modify%20a%20file%3C%2FSTRONG%3E%3CSPAN%3E%3A%20You%20specify%20a%20password%20to%20open%20or%20modify%20a%20file.%20Use%20this%20option%20when%20you%20need%20to%20give%20Read-only%20or%20edit%20access%20to%20different%20users.%20For%20more%20information%2C%20see%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprotect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b599%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EProtect%20an%20Excel%20file%3C%2FA%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1529517%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529598%22%20slang%3D%22en-US%22%3EBetreff%3A%20Setting%20a%20password%20to%20open%20or%20modify%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529598%22%20slang%3D%22en-US%22%3EMaybe%20these%20instructions%20will%20help%20you%2C%20if%20not%20please%20ignore%20them%2C%20if%20so%2C%20a%20small%20feedback%20with%20thumbs%20up%20would%20be%20good.%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20In%20the%20Tools%20menu%20under%20Protection%2C%20select%20the%20command%20Allow%20users%20to%20edit%20areas%20...%20(only%20available%20if%20the%20worksheet%20is%20not%20protected)%20and%20click%20the%20New%20...%20button.%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20A%20title%20is%20entered%20in%20the%20Title%20field%20for%20the%20area%20for%20which%20you%20share%20access.%3CBR%20%2F%3E%3CBR%20%2F%3E3.%20In%20the%20Refers%20to%20cells%20box%2C%20type%20an%20equal%20sign%20(%3D)%2C%20then%20type%20a%20reference%20or%20select%20the%20range.%3CBR%20%2F%3E%3CBR%20%2F%3E4.%20A%20password%20for%20access%20to%20the%20area%20is%20entered%20in%20the%20Password%20of%20the%20area.%20The%20password%20is%20optional%3B%20if%20you%20do%20not%20provide%20a%20password%2C%20all%20users%20can%20edit%20the%20cells.%3CBR%20%2F%3E%3CBR%20%2F%3E5.%20Click%20Permissions%20and%20Add%20...%3CBR%20%2F%3E%3CBR%20%2F%3E6.%20Select%20the%20users%20you%20want%20to%20grant%20access%20to.%20To%20select%20multiple%20users%2C%20hold%20down%20the%20CTRL%20key%20while%20clicking%20on%20the%20individual%20names.%3CBR%20%2F%3E%3CBR%20%2F%3E7.%20Confirm%20with%20OK%20and%20enter%20the%20password%20again%20when%20prompted.%3CBR%20%2F%3E%3CBR%20%2F%3ESteps%201-7%20must%20be%20repeated%20for%20each%20area%20for%20which%20you%20want%20to%20grant%20access.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

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 need. However, when I click the link and go to Protect an Excel File, these instructions only tell me how to look the entire access to the file with a password. I do not get information on how to give some people one kind of access and others another kind of access. Can anyone help me? Thanks!

 

Setting a password to open or modify a file: You specify a password to open or modify a file. Use this option when you need to give Read-only or edit access to different users. For more information, see Protect an Excel file.

1 Reply
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)