SOLVED

Protecting MS Excel fie

%3CLINGO-SUB%20id%3D%22lingo-sub-2401164%22%20slang%3D%22en-US%22%3EProtecting%20MS%20Excel%20fie%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401164%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3ECould%20you%20please%20explain%20how%20can%20I%20protect%20MS%20Excel%20(Office%20365)%20file%20with%20password%20so%20that%20it%20offers%202%20options%3A%26nbsp%3B%3CBR%20%2F%3E1)%20open%20and%20edit%20file%20after%20entering%20the%20password%3C%2FP%3E%3CP%3E2)%20open%20file%20in%20read-only%20mode%20without%20entering%20the%20password.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20obliged%20for%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETomasz%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2401164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2401197%22%20slang%3D%22en-US%22%3ERe%3A%20Protecting%20MS%20Excel%20fie%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F837504%22%20target%3D%22_blank%22%3E%40Tomasz_Scianowski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPress%20F12%20to%20activate%20the%20Save%20As%20dialog.%3C%2FP%3E%0A%3CP%3EClick%20on%20the%20Tools%20menu%20to%20the%20left%20of%20the%20Save%20button.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0459.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F285117iD0E753FEBB15BDF5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0459.png%22%20alt%3D%22S0459.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ESelect%20'General%20Options...'.%3C%2FP%3E%0A%3CP%3ELeave%20the%20'Password%20to%20open'%20box%20empty%2C%20and%20enter%20a%20password%20in%20the%20'Password%20to%20modify'%20box.%3C%2FP%3E%0A%3CP%3EDon't%20forget%20this%20password!%3C%2FP%3E%0A%3CP%3ETick%20the%20check%20box%20'Read-only%20recommended'.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0460.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F285120i79DB3E5756E2D300%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0460.png%22%20alt%3D%22S0460.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EYou%20will%20have%20to%20enter%20the%20password%20again%20as%20confirmation.%3C%2FP%3E%0A%3CP%3ESave%20the%20workbook.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2401246%22%20slang%3D%22en-US%22%3ERe%3A%20Protecting%20MS%20Excel%20fie%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401246%22%20slang%3D%22en-US%22%3EDear%20Hans%2C%20thank%20you%20a%20lot.%20It%20was%20difficult%20for%20me%20to%20find%20this%20option%20in%20the%20online%20help.%20I%20appreciate%20your%20engagement.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello.

Could you please explain how can I protect MS Excel (Office 365) file with password so that it offers 2 options: 
1) open and edit file after entering the password

2) open file in read-only mode without entering the password.

 

I would be obliged for help.

 

Thank you in advance.

 

Tomasz

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Tomasz_Scianowski 

Press F12 to activate the Save As dialog.

Click on the Tools menu to the left of the Save button.

S0459.png

Select 'General Options...'.

Leave the 'Password to open' box empty, and enter a password in the 'Password to modify' box.

Don't forget this password!

Tick the check box 'Read-only recommended'.

Click OK.

S0460.png

You will have to enter the password again as confirmation.

Save the workbook.

 

Dear Hans, thank you a lot. It was difficult for me to find this option in the online help. I appreciate your engagement.