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.

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

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.