True, I was thinking specifically about Outlook, where you can only handle
the ribbon using a COM addin and not with VBA or macro code at all.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"Tony Jollans" <My forename at my surname dot com> wrote in message
But, depending on the application, you may be able to assign a shortcut
key to the same underlying command/macro.
www.WordArticles.com- Hide quoted text -
- Show quoted text -
I have an xlam file in xlstart folder which initiates my custom ui tab
whenever i open my excel.
I wanted to set shortcut key for one of the macros in that .xlam file,
but excel does not list all those macros in that workbook.
I am able to see all the macros in my personal.xlsb, other workbooks,
but not that .xlam, so i am not able to set shortcut key for any of
the macros in that file.
as an alternative, i assigned shortcut key to a macro in personal.xlsb
and created another button in .xlam and referred this macro, only to
get "wrong arguments" error.
any solutions?