Individual Passwords per sheet

I have created a workbook, it has 5 sheets, various formula's link to cells on the other sheets in the same workbook. Everything works fine, except passwording it.

Currently someone opens the worksheet, if there is a password, they go through unlocking it, however if they save it and close, next time they open it, there's no password.

What I'm trying to do is a seperate password on each sheet coded in through vb so that everytime someone wants to edit a particular sheet, they'll need to put the password in. I don't mind if the password has to be included in the vb code.

hi,
see if it helps you...
continue for rest of yr sheets

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

That's the right idea John, but it would be bothersome to have to keep entering passwords as the user moved back and forth from sheet to sheet while working, they already entered the password once, so that should "stick" for their session.

I would recommend trying out putting all the passwords into the Workbook_Open macro to reset them all when the book is first opened, any sheets that are legitimately unlocked will stay unlocked for that session.

In ThisWorkbook

Please Login or Register  to view this content.

This is less cumbersome, but this is still far from secure. If a person opens your workbook with macros disabled, this wouldn't trigger. It's a whole 'nother topic, so Google "Excel VBA force macros" for some great suggestions on making your workbook unusable if macros are disabled.

hi JBeaucaire,
you're right! I use it for some sheets!
...but I did not understand what he meant by "(...)so that everytime someone wants to edit a particular sheet, they'll need to put the password in"