Macro's Do Not Work In Shared Workbook : Excel 2007

[outlook]

Hi,

I wonder if anyone can help me ...

I have various different macros, all of which work well, along with my protected sheets. However when I share my workbook, the macro's do not work and the following error appears:


" Run-time error '1004';

Unprotect method of Worksheet class failed."


If I un-share the workbook, everything works fine again.

Why does this happen? Is there anyway I can correct this as I really need to share the workbook?

Thank you.

Hannah.