Excel VBA compatibility check

[ecchahine]

Hi! I have developed a pretty complex macro enabled workbook with a bunch of userforms and sub routines using Office 365. When I was done I wanted to test my project on older versions of Excel (2013 to be specific) and the errors started raining. I ticked the "Missing" section in references and still, there was a lot of incompatibility.

I was wondering if there is an easy way to check my project's compatibility as I am planning to distribute it online in hopes of some extra income.

Thanks!

 

[diddi]

not sure of an answer, but i deliberately do all my development in 2010. apart from laziness not wanting to learn newer versions, the benefit is that newer version have backwards compatibility. i know i loose out on some features, but if you are a heavy VBA user, there are pretty much no great leaps in the VBE anyway.