View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
donh donh is offline
external usenet poster
 
Posts: 13
Default How ignore ribbon code when in Excel 2003

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/