Hi All!
I have a worksheet1 and want the users (employees) to enter the data in it, but if they enter any value that must be locked itself, so that they can't delete the data.
Can you plz please test my below codes and make the required corrections in it?
1) How can I add UserInterFaceOnly:=True in the protection, so they are just allow to format the cell/ cells, but can't delete anything?
2) If I select more than one cell (range) whether they are blank or not, but my codes give an error msg — Run-time error '13': Type mismatch
MS Workbook 2007
Kindly find the attached for more information.
Bookmarks