Protecting cells/data so they can't be changed after saving the file

[thanhie]

Hello,

I have a worksheet where column M, N, P and Q are already password protected. Data is entered on this worksheet by Project Managers who tend to type over cells that already have text/numbers (relevant data) in them. What i would like to do is let the project managers type in Column A and Column B (specifically range A4:B1000) however, once they have saved the worksheet, i want everything that was typed in those columns/cells to be protected so they can't be deleted or written over.

I have zero knowledge in programming/vba/macros so your help is much appreciated!!!!

[chinraj]

Try this,

Please Login or Register  to view this content.

If the PM wants to delete/overwrite, then they should unprotect(got to Review ->Unprotect Sheet) the sheet with password
PS: To change the reference cell/columns that your needs and password as well.

[thanhie]

thanks so much for your help and response. i have zero knowledge of macros. the code / programming language that you provided me above, where do i go to type it in? how do i run the code? Can you please show me step by step?

[chinraj]

Steps:
1. Right click on sheet tab where you want to apply this macro
2. Select 'View Code'
3. Paste the above code in right side editor pane(Modify the range and password line 4 and 5,11 respectively)
4. Press Alt+Q and Save the workbook once again
5. Verify the result

[thanhie]

OMG It works perfectly just as I had wanted! Thank you so much! I really appreciate it!

if i wanted to know exactly what the code above means, should i create a new thread? If so, i will mark this thread as "SOLVED."

Again thanks so much!

[thanhie]

One more thing though....when i type over any cell between a1:b1000 after i wrote in it and saved the file.....a pop up comes up asking for a password. This is perfect since this is what i want it to do. However, when i type the actual password in the popup box it doesnt work. i have to go in and unprotect the sheet then type in the password from there in order for it to work. what is happening there? why doesn't the password work when the popup box asks for the password? thanks a lot!