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/