I'm creating this inventory worksheet for my pharmacy.
Cells B8:D25 are accessible only by the pharmacist with the password "Bruce".
Cells E8:G25 will be where the technicians enter data.
I'm trying a VBA that is supposed to lock the cell after the technician enters a value.
The code works on a brand new worksheet, but with my worksheet I think my various protections are somehow interfering with the code.
I have attached my worksheet to this post.
Thank you
Bookmarks