A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Thank you HansV very much for your time.
I followed your instructions very carefully.
This is what happened
1- Using a copy of my original file, when I entered your first code in the worksheet module, and your second code in the standard module then pressed F5; the cells already contained data could no longer be edited, that is good. But when I tried to enter data in empty cells this was possible but I got the error message attached
When I tried to unprotect the sheet, this was not possible and gave me the error message attached (I am sure my password is correct which is secret as in your code).
I saved the file, exit and reopened it.
Now the cells edited after applying your codes could still be modified (with the same error message display) and could not be protected.
How can these errors be fixed?
2- Using another copy of my original file, when I did not enter your first code in the worksheet module, and I only used your second code in the standard module and pressed F5; the cells already contained data could no longer be edited, and I can edit empty cells with no error message. That is exactly what I need.
I saved the file, exit and reopened it, now the data entered after applying your code could still be edited and are not protected.
When I tried to unprotect the sheet, this was not possible and gave me the same error message as in method 1 (I am sure my password is correct which is secret as in your code).