I've not experienced code that works in an earlier version but
bombs in a later version. Can you provide some examples?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Wboson" wrote in message
...
This does not always work as the underlying object model has
changed. Is this
not your experience? (See post titled Code to different object
models,
9/8/05).
--
John



"Chip Pearson" wrote:

You must write your code to work on the earliest version on
which
it will run.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ACFalcon" wrote in
message
...
I am rather new to using Excel macros, but I have recently
made
an Excel
sheet with a VBA macro in Excel 2003. Some of our network
users are still on
2000 or 2002 versions of Excel. Therefore they received
compile errors when
they try to use the macro. Is there any way to make this
VBA
macro work on
their versions? Is there some sort of controls update that
they can do to
make this macro work, or is this macro going to only work on
Excel 2003 and
there is nothing I can do about it?

Thanks for the assistance,
ACFalcon