Dev in Excel 2016 - but problems in Excel 2010 (Option Explicit)
Posted on 2016-10-28
I developed an Excel VBA application in Excel 2016, to be deployed for running in Excel 2010.
In Excel 2010 I get an error "Can't find project or library"
On looking into this I find that ...
Excel 2010 seems to default to Option Explicit. Although I should (!) I have not declared all my variables. How can I turn Option Explicit on?
BUT more interestingly ....!
When I go to the IDE and look in Tools, References is greyed out. So I can't even check if any component is 'missing'.
What's going on here?