[Last Call] Learn how to a build a cloud-first strategyRegister Now


how do i create shortcut to run macro in excel 2003?

Posted on 2014-07-16
Medium Priority
Last Modified: 2014-08-01
Question by:gvilbis
LVL 34

Expert Comment

by:Rob Henson
ID: 40198963
We would need some more detail to answer the question.

Where do you want the shortcut?

Author Comment

ID: 40198970
if i would like for example that Control+R will run the macro, how i do that?
LVL 10

Accepted Solution

Gašper Kamenšek earned 2000 total points
ID: 40199076
Tools menu/Macro/Macros
In the Macro name box, enter the name of the macro you want to assign to a keyboard shortcut key.

Click Options.

 If you want to run the macro by pressing a keyboard shortcut key, enter a letter in the Shortcut key box. You can use CTRL+ letter (for lowercase letters) or CTRL+SHIFT+ letter (for uppercase letters), where letter is any letter key on the keyboard. The shortcut key cannot use a number or special character, such as @ or #.

 Note: The shortcut key will override any equivalent default Microsoft Excel shortcut keys while the workbook that contains the macro is open.

Hope this helps

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question