Getting Macro Short cut keys

Getting Macro Short cut keys

Greatest place to be

Thanks for visiting my site lucky visitor:

If you've ever wanted to get the short cut keys for your macros listed then here is an Addin that will help you get these............you know the ones that you have continually added to BUT have now lost a list of them :-)

You could have done this manually via;

Tools > Macro > Macro

Then selected the macro and > Options

Then copied the Shortcut key as >>>>>>>>

But what if you have 100's, or you need to

get them from an Addin or

Personal workbook.

The Addin below will do this for you. Testing done on Xl97 and Xl2000, but this should work for Microsoft Excel XP.

This Addin will give your;

1) Module name where the routine is stored

2) Macro Name

3) Shortcut key

4) Macro description

Please NOTE: position of ShortCut Key Addin command (See Image below)

Down load Addin file from here

This page was last updated on: February 3, 2004

Xl2003 Version, should also work for Xl97

Code amendments: 7th Oct 2004 - thanks to Peter T Thank you Peter!

30th April 2007 Code amendment

Thanks to Don Wells for pointing out a problem with the PERSONAL.XLS file. This amendment takes care of the PERSONAL.XLS File. Appreciate ALL Feedback!

Can Do

Ivan F Moala

Visits here

Creating macro keys for Excel will make document sharing easier, so turn every PDF into Excel documents with a convenient PDF converter. Now, with new technological advancements, you can turn just a PDF into just about any document, so convert PDF to Word of Excel and work with a document you're familiar with.