Unprotect sheets in workbook deactivate event

Hi,

Try placing your worksheet unprotect code into the Workbook_BeforeClose subroutine also, found in the ThisWorkbook module.

Let me know if this helps