The simplest thing is to have your macros unprotect the sheets, do their thing, then reprotect.