Help with shared workbooks and maintaining content protection
 

I have to have a workbook shared. Then perform changes to the
contents of a protected worksheet.

so i have to unprotect it to change the contents, and then of course
re-protect the sheet after the macro work is completed. this is where
it fails.

Any suggestions?