how to unprotect sheet using - prompting user input

[sathib]

I need a solution to unprotect by user if he suplied the password by typing in input box.

my code:--

Please Login or Register  to view this content.

-- once it is locked .. when i try to edit something .. it says sheet is protected message..
what I need is to promt an input box to enter password..


thanks

[sathib]

Apprceiate any inputs..!!

when I get the message "worksheet is protected", where the control goes? is it to worksheet_change??

[sathib]

how do i code to prompt input box for a password to unlock protected sheet?

[sathib]

is there a way try editing a cell pop up with input box saying worksheet protected, please enter password?

[Leith Ross]

Hello sathib ,

An InputBox will not hide the password as it is typed. It is better to add a UserForm to your VBA project to handle the password entry and validation. The UserForm only needs two controls: A TextBox and a CommandButton. Once you have determined the cell changed was in either column "E" or column "J" you can call the UserForm. Here is the code for the Worksheet_Cjhange event and the UserForm code. All control names are the default names.

Worksheet Change Event

Please Login or Register  to view this content.

UserForm Code

Please Login or Register  to view this content.

[sathib]

Thank you very much Leith Ross for your solution. I already have worksheet_change sub in my code.
I dont know how another worksheet_change will behave. I will give it a try..

[sathib]

Thank you very much Leith Ross for your solution.

Unfortunately I could not resolve my issue.

Here is what happened.
1. I selected all sheet and format -> cells -> protection-> locked (uncheck)

2. Selected my cells that I need a lock on it.. did the reverse of above process.

3. Gone ahead and protected my sheet tools --> protect

4. Copied your code.


When I try to change my cell value that is locked, default message pops saying it is protected. My control does not goes to worksheet_change sub at all. .



Anything I am missing here...!!

thanks