How to protect Workbook from Editing

%3CLINGO-SUB%20id%3D%22lingo-sub-1485981%22%20slang%3D%22en-US%22%3EHow%20to%20protect%20Workbook%20from%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485981%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20strange%20situation%20where%20I%20need%20to%20protect%20a%20workbook%20from%20editing%20but%20would%20like%20to%20keep%20it%20so%20that%20it%20is%20still%20viewable%20without%20a%20password.%20I%20know%20that%20you%20can%20protect%20locked%20cells%20on%20a%20particular%20worksheet%2C%20but%20the%20document%20I%20am%20working%20with%20has%20about%20100%20different%20sheets%20in%20it.%20Is%20there%20a%20way%20I%20can%20protect%20all%20the%20sheets%20from%20being%20edited%3F%20Without%2C%20needing%20a%20password%20to%20open%20the%20workbook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1485981%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486055%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20protect%20Workbook%20from%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486055%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20set%20the%20workbook%20to%20be%20read-only%2C%20unless%20the%20user%20enters%20a%20read-write%20password%20(optional)%2C%20would%20that%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486065%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20protect%20Workbook%20from%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486065%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20might%20work..%20How%20would%20I%20go%20about%20setting%20that%20option%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486102%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20protect%20Workbook%20from%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486102%22%20slang%3D%22en-US%22%3EI've%20attached%20a%20gif%20to%20my%20previous%20reply.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486137%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20protect%20Workbook%20from%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486137%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F708976%22%20target%3D%22_blank%22%3E%40BeachITguy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExactly%20the%20same%2C%20just%20another%20way%20to%20set%20(File-%26gt%3BInfo-%26gt%3B...)%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20753px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200730iAF799057C644F921%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486209%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20protect%20Workbook%20from%20Editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486209%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20I%20am%20testing%20it%20out%20now.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I have a strange situation where I need to protect a workbook from editing but would like to keep it so that it is still viewable without a password. I know that you can protect locked cells on a particular worksheet, but the document I am working with has about 100 different sheets in it. Is there a way I can protect all the sheets from being edited? Without, needing a password to open the workbook?

 

Thank you.

5 Replies

You can set the workbook to be read-only, unless the user enters a read-write password (optional), would that work?

That might work.. How would I go about setting that option? @Jan Karel Pieterse 

I've attached a gif to my previous reply.

@BeachITguy 

Exactly the same, just another way to set (File->Info->...)

image.png

Thank I am testing it out now.@Jan Karel Pieterse