Macro shortcut from XLA

  • Thread starter Thread starter Conceptor
  • Start date Start date
C

Conceptor

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.
 
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
 
Back
Top