Forum Discussion
How can I hide and lock certain spreadsheets in a workbook?
I have a workbook with employee information that needs to be put in a public folder for employees to have access to. Is there a way I can hide about 5 of the worksheets allowing other employees acce...
Yes you can hide the tabs and protect the workbook.
BUT: Given that this is personal information you create a huge privacy issue by doing so because it is very easy to remove the password and subsequently unhide the sheets with sensitive information.
My Advice: If an Excel file contains information your recepient is not allowed to see, completely remove that information from the file before sending or sharing.
BUT: Given that this is personal information you create a huge privacy issue by doing so because it is very easy to remove the password and subsequently unhide the sheets with sensitive information.
My Advice: If an Excel file contains information your recepient is not allowed to see, completely remove that information from the file before sending or sharing.