Macros not working for 2 people only

[rea49495]

Hi Everyone. I produce an Excel report that contains macros. This is sent out to many different sites across the country and internationally (audience of about 50). The report has been fully operational for all users except 2. They are the only 2 users at one particular site and also the only users that have been upgraded to Office 2010. The report was created with Excel 2007 and all other users are using either 2007 or 2000. The macros that are in the file are VERY simple (ex. radio buttons to filter pivot, buttons to move to the next sheet, etc.). The users have macros enabled and I've tested the file with all connections removed... still not working. They both have the same Reference Libraries selected as I do, however, they have 14.0 Object Library instead of 12.0. I don't think that backward compatibility would be an issue since they have the more recent version of Microsoft Office, but could this be part of it?
The error message they receive is "Cannot run the macro 'ReportName.xlsb'!Details8'. The macro may not be available in this workbook or all macros may be disabled."
Any ideas?

 

[SpillerBD]

Its the versioning. I'm looking at John Walkenbach's book, "Excel 2013 Power Programming with VBA" and he notes there are many version differences between 2007 and 2010, and the coding required is significant too. It is naturally easier to create backward compatible than forward compatible.
While its easy to create a compatible Pivot Table going from 2013 backward to 2007, any VBA code has to be written to accommodate both versions. And the reason some run two Office versions on their machines....