assigning shortcut keys

[macroNubee]

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

 

[Bagsy Baker]

At the end of your formula, add +N(" your comments"). Anything which appears inside of the quote marks will be assigned the value of zero. When you edit a formula, you can see the comments within the formula.