Hi Everyone,



I read a report that with this syntax ...

Application.MacroOptions Macro:="roevpb", Description:="Beschreibung", ShortcutKey:="ALT+q"

... one could declare the ShortcutKey needed to run a macro.

We have used the manual selection (in the menus) of this and that worked OK but we really need to define this in the code because the application will be rolled out to others.

Can anyone help us with this?

And we also need a way to programmatically add icons/macro calls to the ribbon. Any ideas how this can be done? So far there are recommendations to use blocks of XML to define this but that all seems very complicated.

Thanks very much,
Alan Searle