Hi,

In the absence of the workbook so just a guess, but I suspect that there's a Sheet Deactivate event macro which is re-protecting the sheet. In which case just delete the Sheet.Protect code in the macro.

Regards