Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When I rename a module the keyboard shortcut stops working
I've recorded a macro, and assigned it a shortcut key on recording. After
cleaning up the code, I rename the module to a more descriptive name, the shortcut key stops working. Nothing happens when I press the Ctrl+Shift+[Letter] combination. Even if I try to reassign the shortcut using the (Alt+F8) macro dialogue box, nothing works. All I get is the windows "Error" sound. Am I doing something wrong that is breakting the connection. Can anyone help me figure this out? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
When I rename a module the keyboard shortcut stops working
try copy & pasting the macro to Word or Notepad. delete the module
entirely. insert a new module, and copy & paste the macro back again. now try Alt+F8 to assign a shortcut key. hope it helps! :) susan On Jun 19, 1:28*pm, cla99009 wrote: I've recorded a macro, and assigned it a shortcut key on recording. *After cleaning up the code, I rename the module to a more descriptive name, the shortcut key stops working. *Nothing happens when I press the Ctrl+Shift+[Letter] combination. Even if I try to reassign the shortcut using the (Alt+F8) macro dialogue box, nothing works. *All I get is the windows "Error" sound. Am I doing something wrong that is breakting the connection. *Can anyone help me figure this out? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
When I rename a module the keyboard shortcut stops working
What did you name the module?
What did you name the macro? cla99009 wrote: I've recorded a macro, and assigned it a shortcut key on recording. After cleaning up the code, I rename the module to a more descriptive name, the shortcut key stops working. Nothing happens when I press the Ctrl+Shift+[Letter] combination. Even if I try to reassign the shortcut using the (Alt+F8) macro dialogue box, nothing works. All I get is the windows "Error" sound. Am I doing something wrong that is breakting the connection. Can anyone help me figure this out? -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
When I rename a module the keyboard shortcut stops working
I think I finally figured it out. I've been giving the module the same name
as the macro it contains. I guess there's a confusion when tha happens. If I assign different names, the shortcut keys still work. Thanks for pointing me in the right direction. "Dave Peterson" wrote: What did you name the module? What did you name the macro? cla99009 wrote: I've recorded a macro, and assigned it a shortcut key on recording. After cleaning up the code, I rename the module to a more descriptive name, the shortcut key stops working. Nothing happens when I press the Ctrl+Shift+[Letter] combination. Even if I try to reassign the shortcut using the (Alt+F8) macro dialogue box, nothing works. All I get is the windows "Error" sound. Am I doing something wrong that is breakting the connection. Can anyone help me figure this out? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut to pull up sheet menu(copy,delete,rename,etc)? | Excel Discussion (Misc queries) | |||
How you do rename a module? | Excel Programming | |||
Rename Module via VBA | Excel Programming | |||
Keyboard shortcut not working when I copy macro to another computer | New Users to Excel | |||
Rename Module | Excel Programming |