ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   When I rename a module the keyboard shortcut stops working (https://www.excelbanter.com/excel-programming/412839-when-i-rename-module-keyboard-shortcut-stops-working.html)

cla99009

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?

Susan

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?



Dave Peterson

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

cla99009

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



All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com