How to assign a Keyboard Shortcut to a VBA Code

[usama5788]

Hi

I have my own VBA code. I would like to add a keyboard shortcut to my VBA code. I would like to have this particular VBA code only assigned to my own worksheet.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

While your Excel file is active, go to the Developer tab, then at the left select Macros, then select "Macros in this workbook" from the dropdown. Click on the macro "fen" and the click the Options button. For shortcut key, type a letter in the box. I suggest you use an uppercase letter to avoid replacing a built-in shortcut key. This shortcut will work only when this file is open.

If you do not see "fen" in the list, make sure the code is in a generic Module (like Module1) and not in a Worksheet module.