View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christiane Christiane is offline
external usenet poster
 
Posts: 1
Default Where is a macro shortcut key stored in a module?

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/