I'm trying to incorporate Dynamic DV! into an existing workbook per EE article:
For the most part, everything works as advertised.
In another post, the author suggested a slimmer approach in integrating their code into an existing workbook which I am interested in learning how to do:
To integrate the utility (after you're satisfied it does what you want), it would only require the copy of a couple of the modules into your workbook, if that's really necessary, to eliminate the "add-in" effect.
In addition, I have a few more questions...
does this work in older versions of Excel (2007, 2003, etc)?
it appears that the resulting font is larger than the surrounding font. In other words, the drop down font size appears to be 16 whereas my workbook is at the default 12. Any way to control the font size of the drop down?
the article makes mention the use of ActiveX. Could the user via their security settings, disable Dynamic DV!'s from functioning if they disable ActiveX on their system?