Why errors occur in wrkbook w/ vba when saved on Shared folder?

I have a spreadsheet with VBA programming. The spreadsheet is used by
multiple people so the file is placed on a shared drive. When a user tries to
open the file placed on shared drive, there will be an excel error and excel
shuts down. However, when the file is saved on a desktop or opened from
email, there are no errors. What would cause this error on a shared drive?

Could be a sharing violation.
try:
Tools/share workbook

"Shawna Hartman" wrote:

> I have a spreadsheet with VBA programming. The spreadsheet is used by
> multiple people so the file is placed on a shared drive. When a user tries to
> open the file placed on shared drive, there will be an excel error and excel
> shuts down. However, when the file is saved on a desktop or opened from
> email, there are no errors. What would cause this error on a shared drive?