PDA

View Full Version : [SOLVED] Pitfalls of Earlier versions of Excel



austenr
06-20-2005, 11:30 AM
I know there are some differences when writing macros for earlier versions the sort being one of them wher later version inclusons cause problems. I find I have to create a lot of macros for people using 97. Can anyone tell me some of the other considerations when creating for earlier versions? Thanks

Zack Barresse
06-20-2005, 11:49 AM
VBA syntax. Especially in Calculation and AutoFilter. Those are my two biggest bugs. :)

Bob Phillips
06-20-2005, 11:52 AM
Develop under 97 and you won't get any problems. Excel is backwards compatible like any good product should be.

Glaswegian
06-20-2005, 01:11 PM
One thing I always remember in 97 is that Worksheet Change Events won't fire from data validation.

See here http://support.microsoft.com/default.aspx?scid=kb;en-us;172832

Regards