keyboard shortcut for a macro

G

Gary

Hi All,

I copied and pasted a macro in a workbook. now i want to assign a shortcut
key to the macro. How do i do that?

Sorry for being so dumb :(
Gary
 
D

Dave Peterson

Tools|Macro|Macros|select your macro from the list
Click on the Options button to assign the shortcut key combo.
 
G

Guest

From the Excel Window, touch ALT-F8, select the macro, touch Options..

then assign the shortcut
 
G

Guest

You are only dumb if you refuse to ask questions!
In your spreadsheet, press <Alt><F8> On the pop-up select Options, and then
type in the key you want to use.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro shortcut help 1
How do I customize keyboard shortcuts in Excel 2007 4
Keyboard shortcut to follow hyperlink? 1
Assign a keyboard shortcut to the Start menu? 2
running an Access 2003 macro from a keyboard shortcut 3
Excel Excel macro and passwords 3
Keyboard shortcut for add-in 1
Button Click but not Shortcut Key 1

Top