macroNubee
New Member
- Joined
- Apr 9, 2002
- Messages
- 5
Hi I have the following line of code in my
Macro:
Application.OnKey "^9", "myMac"
After running the macro the first time, it will assign to the key stroke "CNTRL+9" the operation of running the macro myMac. It works fine, but after closing the excel file and opening it back up. The "CNTRL+9" key stroke combination does not run myMac.
Does anyone know what I can do to make it so that once you assign an operation to a keystroke, it will work even after you close and open the excel file?
Thanks
Macro:
Application.OnKey "^9", "myMac"
After running the macro the first time, it will assign to the key stroke "CNTRL+9" the operation of running the macro myMac. It works fine, but after closing the excel file and opening it back up. The "CNTRL+9" key stroke combination does not run myMac.
Does anyone know what I can do to make it so that once you assign an operation to a keystroke, it will work even after you close and open the excel file?
Thanks