Password protecting individual worksheets in excel so each person can only view and edit their own

Katie_V   As noted by previous commenters, Excel security is NOT secure! But I have done something similar to what you want for an internal document for training reports so employees can easily see their own reports but if they see others it isn't a big deal either.  I spent some time this evening initially 'scrubbing' my training matrix / report and then decided to just scrap it and write  a very simple PW sheet control.  In the attached is the VBA code to basically do what you want.  On open, all sheets except "Home" are hidden.  Click the button "Login" to gain access.  The admin is Lotus with PW of 123 (thought that was funny).  i also have the PW for the VBA set to 123 and the master sheet/workbook PW set to 123 (that is a constant in the VBA on the frmPassword form code).  After opening with the Admin account (Lotus 123) you can look at the "Main" tab to see how to add users, passwords and "R" or "RW" permissions for each page.  If the macro sees "R" or "RW" it makes the page visible and if it sees "RW" it also unlocks the page.

I really didn't intend to spend this much time on creating this for you/others but I did and it is well past my bedtime so I haven't tested everything, fixed everything, nor added all the features that would be nice. But don't worry, the bugs are included at no extra charge.

AGAIN, Excel is NOT secure and therefore I made no attempt to make this particularly secure.  You could use the "very hidden" and you could encrypt the passwords and much much more, but in the end it is still in excel and therefore inherently NOT particularly secure.

So I hope this might be of some help to you.