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 access to only about 4 other worksheets? I need for the employees not to be able to unhide those worksheets that I hide. I'd hate to have to copy the 4 worksheets into another workbook that the employees would have access to in order to keep certain personal info private. If I do that then when any info changes in those 4 worksheets, I would have to make changes to both workbooks.
1 Reply
- 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.
