Christiane,

The macro key code is stored in the VBA Module, as an Attribute.
If you export the module, and view it in a text editor such as
NotePad, you'll see an Attribute statement with the shortcut key
code. Attribute statements are used by the VBA Editor and
compiler, but are not visible in the code window.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Christiane " wrote
in message ...
Hi,

When I create a macro from Excel, I usually assign it a
shortcut key.

But when I go in the module, I cannot see where this
information is
kept in the code.

Also, I have a second question.

Each time I create a new macro to be stored in the personal.xls
workbook, a new module is created.

When I cut and copy the macro to another module, the shortcut
key
assigned no longer works.

Is there a way to have all the macros I create in the
personal.xls
workbook go in the same module?

Any help will be appreciated.
Thank you.


---
Message posted from http://www.ExcelForum.com/