Dave Petersen answer might work. I cannot test this as I do not have 2007.
However, I do not think you can go "backwards". Like in other Excel
versions, it is difficult to go backwards unless you do not implement any new
references that are only available in the newer version. Use basic coding
that you did in 2003 into 2007 so that it is on a more campatible level.

You are heading for incompatibility problems that may not appear until a
certain combination occurs.
Also, I think, if you use Excel on 64 bit OS back to Excel on NTFS, it might
also cause errors (not sure).

PS You might have to "double-code" ie one for 2007 and one for 2003. Use
code to check the version and OS. This will ensure compatibility. Also, I see
the Mac name and you should also implement code for both platforms ie PC and
Mac if you expect the other platform ie PC, may be used. Try not to use
Functions as they just eat up memory.
Please note - I am not an expert.



"Ed Sowell" wrote:

When I do this I get an error saying it can't find object or library for
CommandBar Menu. My guess is that the XLA file has a reference to the
earlier Office DLLs. How do I make it "let go" of the newer version DLLs and
find the proper library in the Vista/Office 2007 environment?

Ironically, I originally developed most of this XLA under XP/Office 2003,
then migrated to Vista/Office 2007. Unfortunately, I still have to be able
to deploy to an XP environment.

TIA

Ed