Macro not running on shared workbook

[Guest]

I have a shared workbook, when the users try to run the
macro they get a runtime error message. If I take off the
share the macro runs ok. Can anyone tell me if there is a
way around this problem.

Thanks.