| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where is a macro shortcut key stored in a module?
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where is a macro shortcut key stored in a module?
Thanks Chip.
Is there a way I can change the shortcut key without having to redo th macro -- Message posted from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where is a macro shortcut key stored in a module?
Tools|macro|macros
Select your macro, then click options and you'll see a spot for specifying the shortcut key. "Christiane <" wrote: Thanks Chip. Is there a way I can change the shortcut key without having to redo the macro? --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which macro module | Excel Discussion (Misc queries) | |||
| hyperlink, macro, stored procedure? | Excel Worksheet Functions | |||
| Can I create a command box fora macro to be stored on my toolbar | New Users to Excel | |||
| Can I create a command box fora macro to be stored on my toolbar | New Users to Excel | |||
| When open an old xls, an new macro is in a new module. | Excel Programming | |||
Hybrid Mode
