I'm not sure if this should go here or in the macro forum, so if this is in the wrong place please move it.

Where I work, we have many files that have macros in them. When only one user uses these files, we have no issues. However, as soon as these files are used by more than one person they corrupt with the "Can't find library" error. Any time I try searching for this issue online, it takes me to posts about the old shared wookbook feature or gives me a list of ways to try to fix corrupted workbooks. I've found a way to fix the files after they've corrupted, but what I'm hoping to find is a way to stop this corruption from happening at all. Anyone have any ideas?