Dear Sir,
your first macro's answer is for entry in cell and lock cell which is entered data.
now my question was , firstly sheet1 is unprotected and i entered data which my required in whole sheet1,
in sheet 1 only one cell (a1,b1,z1, etc) will remain for protect sheet1. one cell will be...