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?