Al,
Visit Chip Pearson's excellent website, specifically:
http://www.cpearson.com/excel/CreatingCOMAddIn.aspx
It's complicated, but it shows how to capture events from office components (the commandbar,
specifically).
HTH,
Bernie
MS Excel MVP
"Al" wrote in message
...
Is there any way to have a user selection of a particular menu command
recognized as an event to trigger a macro? I want the command to execute
normally followed by the macro. i know I can customize the menu bar to
remove the command and force the use of a control to accomplish this
sequence, but I would llike to avoid that if possible.
--
Al C