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...
It looks as though it would require some coding, if you want to automatically hide and show individual sheets based on individual identities
I would probably keep it simple, adding a macro that would run when the spreadsheet was opened, look up the user's Windows login name, and use that to decide which sheet to open up. Each user's login name could be stored somewhere on their sheet, making it easy for macro to run through the sheets until it found the right login name. This is pretty easy to create.
VBa can make sheets "very hidden", too, meaning they won't even show up in the list of sheets from Excel menus.
Is that the kind of thing you want?
I would probably keep it simple, adding a macro that would run when the spreadsheet was opened, look up the user's Windows login name, and use that to decide which sheet to open up. Each user's login name could be stored somewhere on their sheet, making it easy for macro to run through the sheets until it found the right login name. This is pretty easy to create.
VBa can make sheets "very hidden", too, meaning they won't even show up in the list of sheets from Excel menus.
Is that the kind of thing you want?