Phone (01457) 858877 or email
This short blog shows how to assign short-cut keys to macros in Excel 2010, Excel 2007 and Excel 2003. So if you've written a whizzy macro in VBA and want to be able to run it with a single keystroke combination, read on!
Suppose that you've written a whizzy macro (called, oddly, SpiderPig), and you want to find an easy way to run it.
For more ideas on how to run macros - including assigning them to form buttons, pictures or the quick access toolbar - see this blog on running macros in Excel.
You can press the CTRL key combined with any lower-case or upper-case letter to run your macro, although you'd be advised to stick to upper-case letters. Why? Well:
To assign a short-cut key to your macro is different in Excel 2010, Excel 2007 and Excel 2003, as shown under separate headings below.
To assign a short-cut key to a macro in Excel 2010, first choose to display a list of macros - one way to do this is to click on the Macros button:
Click on the Developer tab on the Ribbon, then on Macros as shown
See this separate blog for how to display the Excel 2010 Developer tab on the Ribbon if you can't see it.
You can now choose your macro:
To assign a short-cut key to a macro:
Finally, choose a short-cut key to assign to the macro and select OK:
Type into the Shortcut key box the letter you want to assign to this macro (using upper case for SHIFT + CTRL combinations, as here)
You will now be able to press SHIFT + CTRL + S to run this macro whenever you have the file containing it open.
This is the same procedure as for Excel 2010, except that the way to display the Developer tab on the ribbon in Excel 2007 is different at the start.
For earlier versions of Excel, the procedure for attaching short-cut keys to macros is similar. First display a list of your macros:
Select the menu shown on the left to display a list of your macros
You can now proceed as for Excel 2010 (behind the scenes in Excel, nothing much has changed!).
Comments on this blog
This blog currently has no comments.