Quote Originally Posted by Norie View Post
Isn't it the worksheet you should be unprotecting rather than the workbook?
Yeah my bad. But I have changed it to xlWorksheet.Unprotect() and xlWorksheet.Protect(). Now it's allowing me to enter data but the problem is the protection is entirely removed. When i open excel the sheet is no longer protected. I want the sheet to be protected