Hello,

I'm using a shared workbook in Excel 2007 and it has macros in it. When I open the workbook Run-time error 1004, Method "protect of object'_
worksheet failed appears. I can only click "end" to close the error. Can someone please tell me how to trap this error so I can prevent it from appearing?

Thank you.

MAB