Using Macros to password protect but also need to stop deletion/editing

Hi,
I need to somehow prevent a user from editing or deleting already entered data.
Im using code to prevent users from selecting other users names from a drop down list but not need to stop it from changing once entered
I'm using the below code

Please Login or Register  to view this content.

So i select 'Pikachu' and enter 123 as a password - working brilliantly but nothing stops me or anyone else from now deleting it.
Everyday there could be 3 or 4 different people using it to check off what theyve done so need to prevent them later deleting what they or someone else has done to cover up any mistakes etc is the idea.

I have found a code that says it will do this but cant get it to work.
TIA

Ok so i think i managed to upload a test excel.

The forms i use at work are too confidential to redact without covering what i need help with so i created an example.
In the Excel file (Which already contains a macro for password protecting names) i have examples of 2 types of forms, one with the 'Names' entered all in the same column and another where the name has to be placed multiple of times in different individual cells
In a recent audit it was pointed out that anyone who uses the forms can just delete another persons entry or change the name of the person who done the job/checks, hence ive learned how to get the 'names' held in a list, password protected.
As you see above i have managed to get 'Names' password protected within a range ie "E:E" but theres nothing stopping me from deleting the 'Names' or what was previously entered in the other cells.
So is there a way I can auto lock the cells with inputted information apon closing/saving the document so the next person/time the file is used the information can not be erased or deleted without the Administrators password?
I am new to using VBA and getting very interested in it so what to properly learn it, so if you can tell me how what where etc needs to be done it would be greatly appreciated

TMS in my sheets, yes the names etc are locked and password protected.
With other users i cant keep locking and unlocking the sheet after each entry myself hence im looking for a code to do it automatically. And the code will be password protected also

Mumps1 the name of the sheet is "Sheet1 (2)" (can have different name on other workbooks though).- this feeds off another workbook, done so i dont have to update each book everytime theres a change to a spec or user etc.

I appreciate your help both of you

Thank you for replying and for the work I really appreciate it.
I have tried but failed to move the code over to my form, I thought I could figure it out easily enough but obviously I'm not as smart as I hoped I was.
My manager has agreed to both, allow me to upload heavily redacted old versions of our forms (sorry im not allowed to post the actual ones), and to look into putting me on a course for both VBA and "Some sort of PC Coding course". So hopefully good things
So please find attached the new Excel files and I know I'm asking a lot but, Could you also somehow explain or guide me to somewhere to understand what each part of the code means/does? Knowing my boss he wont do much this side of 2026.
Thank you very much.
Emmily

Does this work for you, replacing all the sheet1 code:

Please Login or Register  to view this content.

The "stamp" is sometimes used, along with/instead of, our name, most of my forms require both at some point. So be it the name or number it will need a password to select it.
(im sure theres a way where i can select my name and my number will appear in the next box if you know what i mean, so ill only need to enter the password once for that occasion?.)
In EmmilyWillow2 This form is used for a particular device and when that device is swapped then i create a fresh copy that contains the details of the replacement device and then it gets used each shift for checks on that device until swapped again. the "stamp" is my signature to say i done that part of the job so will need to be password protected to select my number, Same for EmmilyWillow1.
In EmmilyWillow1, the new version of this form has a few varients but the details go in about the same place.
Most the left side contain Titles to what needs to be entered like 'Shelf Number' then in the next box '23' to say that is where it is stored for example.
I hopefully have uploaded EmmilyWillow1coloured to show better what im trying to say.
In red is where the titles are and in Yellow is where i need to put my name/number and in-between is where i list the other details of the job(s) so the form is kind of like a list of whats just gone into my freezer, Which freezer, Who put it there, when it went in etc etc.
About 3/4 of these get filled in per shift.
Ive still been playing with the code and last i tried before i got told to stop and eat and lunch was an error because it involved a merged cell...
Still im enjoying this. Thanks for your help so far.

Emmily

With EmmilyWillow1
e12-j12, e13-j13 etc to e28-j28 would be locked with "k"
Yes you are right with f43 so, c29:c44 would be locked with c43, f29:f44 locked with f43 & j29:j44 with j43. With the newer version of this form the cells/rows are slightly different but if i can see in the coding then i can just change the ranges?
The yellow highlighted cells might end about there (im at home now so cant be 100% sure but again if i can pin point the part of the code i could change the range?
In the new version there are less blank rows at the top (about 6 i think) to have the company logo and form number etc located there.
with point 4, yes this is likely to be slightly different but not much
Having read up about VBA and playing with it, it seems merged cells are a pain in the A lol so might have to reconfigure my forms to eliminate the merges.

With EmmilyWillow2 - this seems perfect thank you, i believe i can transfer this to my current form for this style also think i understand

Please Login or Register  to view this content.

basically Including Column A count 6 cells to the right and lock them
Im learning....slowly lol

Thank you so much for all your help so far

Emmily x

Hi Mumps1
Thank you for this.
Slight problem with rows 21-44
No matter what info i put in, it wants a password, not the workbook unlock password either.
Also how did you get it to automatically put in the number below the name?

Many Thanks for all your help so far, hope your having a great weekend.

Emmily

Thank you for all your help, this seems to work perfectly. Im back in work tomorrow after taking time off for my kids school holidays so fingers crossed it go's over ok. Will let you know.
Thanks again you have been very helpful.

Emmily