Teams favors opening files in Excel on-line, which does not understand VBA. That may be part of your problem.