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?
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.