Macro shortcut from XLA
 

Hi

I want the users of my XLA file to be able to press
CTRL+E to trigger a macro inside the XLA. How can I
achieve that? I know that from a XLS file you can
attribute keyboard shortcuts to macros from the Macro menu
in Tools. How can I do the same for the XLA file macros?

Thanks,
C.

Macro shortcut from XLA
 

Hi,

with a xla-file, just do the same, but you have to type the exact name of
the macro in the entry: then the option-button becomes available.

I was wondering if it's possible in VBA?

Greetings
Jos Vens


"Conceptor" schreef in bericht
...
Hi

I want the users of my XLA file to be able to press
CTRL+E to trigger a macro inside the XLA. How can I
achieve that? I know that from a XLS file you can
attribute keyboard shortcuts to macros from the Macro menu
in Tools. How can I do the same for the XLA file macros?

Thanks,
C.