Forum Discussion
Password protecting individual worksheets in excel so each person can only view and edit their own
Hi there, I am looking for a way to protect individual worksheets within in a workbook so that an admin could view and edit all worksheets but staff could only view and edit the worksheet they are a...
Yes, I did not see your response until I refreshed the page.
If the user has to enter a password to decrypt a worksheet, then that seems to be as much work as having them enter a password to unprotect the sheet. And, an admin would have to enter passwords for all of the sheets. I'm assuming that is what the OP is trying to avoid, otherwise, I wouldn't see the point in asking?
If the user has to enter a password to decrypt a worksheet, then that seems to be as much work as having them enter a password to unprotect the sheet. And, an admin would have to enter passwords for all of the sheets. I'm assuming that is what the OP is trying to avoid, otherwise, I wouldn't see the point in asking?
JMB17
I suppose that is the problem with software that is designed to be open and collaborative - it isn't good at being secretive!
I have used AES encryption in several cases over the years, even encrypting individual rows of data with distinct passwords, so that users could "log in" and decrypt and use their individual data without the need for an internet connection.