Add vba code to lock cells on data entry

Thanks for your response Cerbera. However, I do not know where to insert that in the code since I have no knowledge in vb. Would appreciate if you could show me. Below is what is currently in my worksheet:

Please Login or Register  to view this content.

Also, the cells are left unlocked until an entry is made so the user can click the dropdown and make a selection and it simultaneously stamps the time in the next cell.


Thank you!

Timetoshine

Hi Timetoshine,

This code locks the cells.

To do so however, it has to un-protect the sheet first, lock the cells then re-protect it.

If you use a password you'll have to add:

Please Login or Register  to view this content.

At the end of the protect and unprotect lines of code.

Please Login or Register  to view this content.

If this works and you're happy can you close the thread under thread tools and click on the * Add Reputation on my post if you are happy to do so?

Cheers,

Cerbera