Protecting an Excel workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1780146%22%20slang%3D%22en-US%22%3EProtecting%20an%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1780146%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Excel%2097-2003%20and%20thus%20far%20have%20been%20able%20to%20protect%20(Encrypt%20with%20password)%20a%20workbook%20with%20a%20password%2C%20but%20this%20option%20only%20gives%20me%20access%20to%20the%20document.%3C%2FP%3E%3CP%3EI%20need%20to%20protect%20the%20document%20with%20a%20password%20to%20prevent%20accidental%20changes%20from%20other%20viewers%2C%20but%20need%20to%20provide%20them%20with%20a%20read%20only%20option.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1780146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1780276%22%20slang%3D%22en-US%22%3ERe%3A%20Protecting%20an%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1780276%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F832301%22%20target%3D%22_blank%22%3E%40Ruben2011%3C%2FA%3E%26nbsp%3B%20In%20Excel%20under%20the%20REVIEW%20tab%20you%20can%20find%20'Protect%20Sheet'%20and%20'Protect%20Workbook'%20which%20may%20help%20or%20under%20Save%20As%20there%20is%20a%20'More%20Options%20...'%20that%20pops%20up%20a%20Save%20As%20box%20and%20then%20to%20the%20left%20of%20the%20Save%20button%20there%20is%20a%20Tools%20drop%20down%20and%20select%20General%20Options.%26nbsp%3B%20In%20that%20popup%20box%20there%20are%20options%20to%20add%20a%20PW%20to%20open%20and%20a%20PW%20to%20modify.%26nbsp%3B%20If%20you%20only%20add%20PW%20to%20modify%20then%20anyone%20can%20open%20but%20not%20make%20changes.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am using Excel 97-2003 and thus far have been able to protect (Encrypt with password) a workbook with a password, but this option only gives me access to the document.

I need to protect the document with a password to prevent accidental changes from other viewers, but need to provide them with a read only option.

3 Replies
Highlighted

@Ruben2011  In Excel under the REVIEW tab you can find 'Protect Sheet' and 'Protect Workbook' which may help or under Save As there is a 'More Options ...' that pops up a Save As box and then to the left of the Save button there is a Tools drop down and select General Options.  In that popup box there are options to add a PW to open and a PW to modify.  If you only add PW to modify then anyone can open but not make changes.  

Highlighted

@mtarler Going through the save as box is what I needed to protect the document, but yet allow others to read it.

Thank you very much!

Highlighted

@Ruben2011 

 

As Mr. mtarler already informed you, you can do this with the command "Protect workbook". But with Excel you have several possibilities to accomplish something, depending on your needs and knowledge. One of these possibilities is also VBA. Here is additional information about what Mr. mtarler has already described and with VBA macro as an example.

Protect a worksheet

https://support.microsoft.com/en-us/office/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6?...

Protect a workbook

https://support.microsoft.com/en-us/office/protect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517?u...

 

Sub protection ()

     ActiveSheet.Protect Password: = "Password Name", UserInterfaceOnly: = True, DrawingObjects: = True, Contents: = True, Scenarios: = True

End Sub

 

Sub unprotection ()

ActiveSheet.Unprotect Password: = "Password Name"

End Sub

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)