I have a purchase order generator which previously worked without a problem and all different computers at work all running different excel versions from 2007 (on Vista), 2010 (W7) and 2013 (W7). For some reason, it has now stopped working on anything other than 2013. I have some ActiveX combo boxes where you select certain suppliers and job nubers etc from the dropdown list, then a 'generate' button makes the purchase order. On the computers where it doesn't work, none of the ActiveX controls function. The dropdown list doesn't work. I can't manually run the code or anything. It just doesn't function.
This started when another user (2010) used the document to create a new order. He generated it and it all worked fine. Then the program stopped working on my computer (2013). It still worked fine on his. The only way I could resurrect it was to copy all the code and make an entirely new excel document. It was like it computer corrupted it - but it still worked on his computer. So now he isn't allowed to make orders any more as it corrupts the document for everyone but him. But then thinking all was well, the document no longer works on any other computer than one with 2013, except his on 2010! I even tried using old backups (which I wrote on my computer only so no-one has ever opened them but me) and those don't work on anyone else' computer either but ones in 2013.
It's all very strange and makes no sense to me. Only solution I've got right now is to upgrade everyone to excel 2013 which isn't ideal and is expensive.
Suggestions?
Cheers
Bookmarks