Home

password protecting sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-719677%22%20slang%3D%22en-US%22%3Epassword%20protecting%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719677%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20an%20excel%20document%20where%20we%20can%20all%20store%20sensitive%20information.%20The%20goal%20is%20to%20have%20the%20whole%20workbook%20encrypted%2C%20and%20then%20have%20a%20%22master%20sheet%22%20that%20has%20the%20basic%20template%20and%20any%20shared%20information%2C%20and%20then%20have%20each%20employee%20have%20their%20own%20tab%20that%20is%20password%20protected%20from%20viewing%20with%20their%20own%20password.%20So%20basically%2C%20hiding%20the%20sheets%2C%20but%20having%20a%20different%20password%20to%20unhide%20each%20sheet.%20Is%20this%20possible%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-719677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719729%22%20slang%3D%22en-US%22%3ERe%3A%20password%20protecting%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719729%22%20slang%3D%22en-US%22%3EIt%20is%20theoretically%20possible%20but%20only%20if%20each%20employee%20gets%20their%20own%20password%20protected%20file%20(file%2C%20Open%20password).%20My%20advice%3A%20Never%20store%20sensitive%20information%20in%20workbooks%20which%20do%20not%20have%20a%20password%20on%20open%20set%20as%20that%20is%20the%20only%20way%20the%20content%20of%20the%20file%20will%20be%20encrypted.%20Passwords%20on%20worksheets%20do%20not%20encrypt%20the%20content%20of%20the%20worksheet%20and%20are%20very%20easy%20to%20remove.%3C%2FLINGO-BODY%3E
stephaniemarie
New Contributor

I am trying to create an excel document where we can all store sensitive information. The goal is to have the whole workbook encrypted, and then have a "master sheet" that has the basic template and any shared information, and then have each employee have their own tab that is password protected from viewing with their own password. So basically, hiding the sheets, but having a different password to unhide each sheet. Is this possible? 

1 Reply
It is theoretically possible but only if each employee gets their own password protected file (file, Open password). My advice: Never store sensitive information in workbooks which do not have a password on open set as that is the only way the content of the file will be encrypted. Passwords on worksheets do not encrypt the content of the worksheet and are very easy to remove.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies