Home

password protecting sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-719679%22%20slang%3D%22en-US%22%3Epassword%20protecting%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719679%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-719679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719715%22%20slang%3D%22en-US%22%3ERe%3A%20password%20protecting%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719715%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366261%22%20target%3D%22_blank%22%3E%40stephaniemarie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20it%20comes%20to%20sensitive%20information%20then%20I%20do%20not%20recommend%20the%20file%20to%20be%20shared%20that%20defeats%20the%20purpose%20of%20protection.%20Remember%20protection%20can%20be%20bridged%20at%20different%20levels.%3C%2FP%3E%3CP%3EThere%20are%20multiple%20levels%20of%20protection%20in%20Excel%3A%3C%2FP%3E%3CP%3E1-%20protecting%20the%20entire%20file%20from%20being%20Opened%20and%2FOr%20Modified%20while%20Saving%20it%3CBR%20%2F%3E%26nbsp%3BSave%20As%20%26gt%3B%26gt%3B%20Tools%20%26gt%3B%20General%20Options%20%26gt%3B%26gt%3B%20Provide%20Password%3C%2FP%3E%3CP%3E2-%20Protecting%20the%20Worksheet%20%26amp%3B%20Workbook%20structure%3CBR%20%2F%3EReview%20Tab%20%26gt%3B%26gt%3B%20Protect%20Sheet%20%26gt%3B%26gt%3B%20Password%3C%2FP%3E%3CP%3E3-%20Hiding%20the%20Worksheet%20deeply%20so%20it%20cannot%20be%20Unhidden%3CBR%20%2F%3EGo%20To%20VBE%20%26gt%3B%26gt%3B%20ALT%20%2B%20F11%20%26gt%3B%26gt%3B%20Select%20the%20Sheet%20in%20the%20project%20explorer%20(CTRL%20%2B%20R%20%26gt%3B%26gt%3B%20F4%20(Properties%20Window)%20%26gt%3B%26gt%3B%20The%20last%20option%20select%20%22Very%20Hidden%22%20.%26gt%3B%20You%20may%20consider%20also%20protecting%20the%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%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

@stephaniemarie 

Hi 

When it comes to sensitive information then I do not recommend the file to be shared that defeats the purpose of protection. Remember protection can be bridged at different levels.

There are multiple levels of protection in Excel:

1- protecting the entire file from being Opened and/Or Modified while Saving it
 Save As >> Tools > General Options >> Provide Password

2- Protecting the Worksheet & Workbook structure
Review Tab >> Protect Sheet >> Password

3- Hiding the Worksheet deeply so it cannot be Unhidden
Go To VBE >> ALT + F11 >> Select the Sheet in the project explorer (CTRL + R >> F4 (Properties Window) >> The last option select "Very Hidden" .> You may consider also protecting the code.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies