How to lock and unlock worksheet using a password but inside worksheet change event

Hi everyone,

The code below works perfectly as long as the sheet is unlocked when the watched cell changes. By working perfectly, I mean that when the data in the current row column C changes from blank to any data entered, the current static date and time is entered into a cell 26 columns away from cell C in column AC. The problem is that I have been completely unsuccessful using sheet locking and unlocking code in this worksheet change event like I use it within macros. I need for it to unlock the sheet with a password I specify, apply the change and then lock the sheet again and setting the same specified password.

Please Login or Register  to view this content.

I've been trying to use the following to unlock and lock but it doesn't work in the change event.

Please Login or Register  to view this content.

I need some words of VBA guru wisdom. Can you help?

Berlan, I can't thank you enough! It works exactly as I need it to.