I have Office 365, but no one else on in my department will get it until the end of the year. I made a few macros for us to use in excel VBA, but ever since my upgrade any macro I touch upgrades all object libraries to version 16.0. My coworkers are still on 15.0 from the previous version of office.
I've tried late binding, which lets me avoid using any of the program specific object libraries. However, I cannot get remove the reference 'Microsoft Office Object Library 16.0' and it's preventing all of my coworkers from using and macros I create or save.
Is there a way to force my excel vba to use 15.0 libraries?