I have created a VBA based Add-in and have distributed it for a group of people at my company. I am distributing it out as an .xlsm file so the users don't have to find the correct file path to save it in (we have a blend of operating systems and Office versions, most Office 7, a few legacy XP, many Office 2007 and 2010 and a few 2013s). I have one user who when saving the file as .xlam isn't changing the file path and is enabling the macro properly but when he does it, it doesn't add my custom tab to the ribbon and instead opens up the .xlsm file.
As a temporary solution I'm having them drop their tabs with charts (it's a chart formatting add-in) straight into the enabled .xlsm file with the macros enabled to get the functionality but I haven't determined why this is happening. They are using Windows 7 64 bit with Office 2010. Others with this same setup have successfully installed the Add-in and are using it now.
Any suggestions on perhaps a different way to distribute the Add-in or any insight as to what is causing this?
Thanks for any suggestions! :)