assigning shortcut keys

macroNubee · Apr 16th, 2002, 04:10 PM

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 · Apr 16th, 2002, 04:38 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 04:10 PM	#1
macroNubee New Member Join Date: Apr 2002 Posts: 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

Apr 16th, 2002, 04:38 PM	#2
Bagsy Baker New Member Join Date: Feb 2002 Location: Sackville Posts: 39	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.