Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut of macro
Hi,
when I register a Macro (with shortcut) dirctly in worksheet, where does excel put the shortcut code? If I see the macro-code it doesn't exist. Thanks in advance M. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut of macro
I'm not sure if you can actually find that code anywhere...
But excel does store it somewhere. If you rightclick on the module that contains that procedure with the shortcut, you can export it to a file. If you open that exported file (in notepad or your favorite text editor), you'll see the shortcut key. miro wrote: Hi, when I register a Macro (with shortcut) dirctly in worksheet, where does excel put the shortcut code? If I see the macro-code it doesn't exist. Thanks in advance M. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut of macro
Shortcut keys for macros are stored in the module file, although
that code is not visible in the VBA editor. If you export a module to a text file and view it in NotePad or your favorite text editor, you'll see the code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "miro" wrote in message ... Hi, when I register a Macro (with shortcut) dirctly in worksheet, where does excel put the shortcut code? If I see the macro-code it doesn't exist. Thanks in advance M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut to a Macro | Excel Discussion (Misc queries) | |||
Shortcut key to VB macro | Excel Discussion (Misc queries) | |||
Macro Shortcut Key | Excel Discussion (Misc queries) | |||
Macro shortcut key | Excel Programming | |||
Macro shortcut from XLA | Excel Programming |