Locking/Unlocking worksheet

[amir9s]

I'm pretty new to vba and not sure how complex what I need is.
I'm trying to create 2 clickable buttons on my sheet, one stating "Lock" and one "Unlock". When click on Lock, it asks for password and password confirmation to lock the file, and stores that password for when the file needs to be unlocked. and when click on Unlock button, it asks for password once and unlocks the file.

Locking the model would entail hiding some cells on the current worksheet and all other tabs.

I think this is not an easy one, so any tips, suggestion, recommendation... anything really helps. Thanks in advance!

 

[Jeffrey Mahoney]

Well amir, you can get there by recording macros (partially). Record a macro during the hiding of cells and locking the sheets. You'll need to create a form for asking what the password is. The same form could be used to lock or unlock the model. Then, of course, you'll need to create a couple buttons. Each of those tasks aren't hard. You'll probably need some help piecing together the code after you record the individual macros.

Jeff