Solved: Macro to unprotect and protect in shared workbook

[belly0fdesir]

This site has been so helpful to me and I am extremely thankful for that. I have another question.

This question has been x-posted here (http://www.mrexcel.com/board2/viewtopic.php?t=193073).

I have a macro that needs my sheets to unprotect to run, so I have it unprotect, then do it's thing, then protect the sheets again. However, I need my workbook to be shared and I cannot unprotect my shared workbook. The macros just won't work if the workbook is shared. Does anyone know a way around this?

[belly0fdesir]

I've marked this topic solved because I realize there is no way around this. I will simply accomodate the obstacle by leaving the workbook unshared and allowing only 1 user to make changes at a time. Thank you for you time.