Hi Dkenny

I did as you mentioned but it gives me the following error.

Runtime error 1004
"unable to set the unprotect property of the worksheet class"

i have protected the sheet thru the tools menu. and in the above code i have used the same password to unprotect & reprotect but whenever i try to change the cell it prompts for a password and when i key in the password it gives the above error message.

thankx