I can only think that the macros are stored in a personal workbook then. Maybe that's a shared workbook and only one person can access it at any time.

It's not a problem that I have ever experienced so I don't really know what more to suggest. You should research .xlsx and .xlsm files to understand what you can and cannot do.

Introduction to new file-name extensions

Easier detection of documents that contain macros Files that are saved by using the default x suffix (such as .docx, .xlsx, and .pptx) cannot contain Visual Basic for Applications (VBA) macros and XLM macros. Only files with file-name extension that end in an m (such as .docm, .xlsm, and .pptm) can contain macros.


Regards, TMS