LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default How to map a shortcut key to a routine in COM AddIn for Excel 2007

"GS" wrote in message
...

I use COMAddins but I don't build my menus there; I use a xla for this and
redirect all controls' OnActions through a single procedure that serves as
an entry point to the COMAddin's procedures. It uses the appropriate calls
from within Excel to use the procedures inside the COMAddin. (No code is
in the xla other than what's required to create/remove menus/toolbars.


Curiosity, why bother making it a ComAddin if it's only going to be called
from a UI created by your xla, with Onactions to your xla. IOW simply the
xla as a wrapper to call the aX dll. You could dispense with the Connect
class altogether.

Regards,
Peter T


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete addin in Excel 2007 Ken Excel Programming 2 April 2nd 10 11:11 AM
Excel 2003 AddIn in 2007 Phil Hibbs Excel Programming 1 November 3rd 09 01:51 PM
patternfill addin Excel 2007 Roland Charts and Charting in Excel 4 September 26th 09 11:13 AM
patternfill addin Excel 2007 Roland Excel Discussion (Misc queries) 1 September 15th 09 04:14 PM
Excel 2007 VBA Addin MR From Texas[_2_] Excel Programming 5 September 3rd 09 03:15 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"