You can't change the protection in a shared workbook. If you explain
what you're trying to do during the protect and unprotect, perhaps
someone could suggest a different way to accomplish the task.

Andrew wrote:
I want to share a workbook that has macros and is on a network. The macros
(amongst other things) will protect and unprotect the sheet but once I make
the workbook shared I lose this functionality.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html