How to add keyboard shortcut to macro un add-in ?

[news.microsoft.com]

How to add keyboard shortcut to macro un add-in ?
I just have a function and I save it as excel addin.
and copied it to addin folder.

I want to execute the macro with a keyboard shortcut for example ctrl-r

preferablely I want to list the macros and select because later on I
make other macros.

two cases, I need

Thanks in advance.

 

[Pete_UK]

You can't execute a function with a keyboard shortcut - you must call
it from another macro or from a worksheet formula like:

=my_function(parameters)

in which case it will return the result to that cell.

Hope this helps.

Pete

 

[JP]

You can set a shortcut key for your macro using the MacroOptions
method of the Application object.

Check out:

http://msdn2.microsoft.com/en-us/library/aa195786(office.11).aspx

HTH,
JP

 

[Dave Peterson]

If you get lots of macros, you may find remembering shortcuts is too taxing.
(It is for me!)

You may want to give the user's an easier way to run your macros.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.