Jon
It works! I put the Application.Run command inside an If statement so that
it only executes when in the Excel 2007 environment. In Excel 2003, the
statement is not executed, the module containing all the 2007 macros is not
compiled, and everything works correctly.

Thanks greatly for this advice.
--
Don H.


"donh" wrote:

Jon,
This seems like it should work. I appreciate the suggestion; thanks. I'll
report back with results.
--
Don H.


"Jon Peltier" wrote:

If you are going to use another workbook, you don't need this complication.
However, as I was clicking on this post I was already thinking of a
solution, and it also uses Application.Run:

Application.Run "'" & ThisWorkbook.Name & '!Excel2007Procedure"

This won't cause anything to compile, because does not call the procedure
until run time.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/