Hi everyone. It's been almost a year since I posted the above question, that was really baffling me. The key piece of information that I was not understanding, was that the macros my team uses are generally stored in PERSONAL.xlsb. The trick is just to get that file open, and make sure all the macros are there.

Excel doesn't make this simple, requiring you to "unhide" the file, but then "hide" it again, otherwise it opens everything you use the program. It's resolved now, though. Just in case ya wondered..... :-)