View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default VBA Macro Versions

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