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
Password Generation and Password Reveal are Not working
HotCakeX in Discussions on
5 Replies
Re-request password
Serhii Zahuba in Outlook on
9 Replies
Bug in Edge insider password manager
HotCakeX in Discussions on
15 Replies
Separate lines on Sheets depending on condition
Mohammed Almaghi in Excel on
1 Replies