Forum Discussion
stephaniemarie
Jun 25, 2019Copper Contributor
password protecting sheets
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 ...
JKPieterse
Jun 25, 2019Silver Contributor
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.
youli2490
Oct 24, 2023Copper Contributor
I don't understand. How does that work? Would appreciate if you told me the steps.