| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Module naming
If I leave the module that my macro is in named Module1, the shortcut key for
my macro works. If I change the name of the module, the shortcut key doesn't work. Is it acceptable to change the module name? How do I connect the shortcut key to the new name? Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Module naming
Re-set the short-cut-key:
In the worksheet (not VBA) touch ALT-F8. Then select the macro. Then click Options.. Then enter the short-cut-key -- Gary's Student "Dan" wrote: If I leave the module that my macro is in named Module1, the shortcut key for my macro works. If I change the name of the module, the shortcut key doesn't work. Is it acceptable to change the module name? How do I connect the shortcut key to the new name? Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| Run worksheet module code from workbook module? | Excel Programming | |||
| Calls from sheet module to ThisWorkbook module | Excel Programming | |||
| Variable from a sheet module in a class module in XL XP | Excel Programming | |||
Linear Mode
