Prev: Special character in Input Message - Data Validation
Next: UserForm1.ComboBox1 to initialize
From: Ed from AZ on 18 May 2010 16:17
Over the years, I've recorded and written a lot of macros. (Probably
time to take a week or two and go over them and delete at least
half!) I assigned a keyboard shortcut to a lot of them.

I seem to remember that before XL 2007, there was a keyboard organizer
that I could go through and review what shortcuts I had already
assigned to my macros. I can't find that in 2007, though.

Is there an easy way to generate a list of all my keyboard assignments
and what macros they go to?

Ed
From: Peter T on 19 May 2010 12:05
I don't recall ever seeing any such keyboard organizer in 2007.

Canned from a previous post -

Macro Shortcuts are stored as hidden attributes of the macro. AFAIK can only
be found by exporting the module and finding the particular attribute in the
text file or view in a text editor.

Try Ivan Moala's addin
http://www.xcelfiles.com/GetShortCutKeys.html

I see my name is still on that page from 6 years ago!

Regards,
Peter T



"Ed from AZ" <prof_ofwhat(a)yahoo.com> wrote in message
news:d5559d87-a429-424d-bb33-c7bdbaee3311(a)y18g2000prn.googlegroups.com...
> Over the years, I've recorded and written a lot of macros. (Probably
> time to take a week or two and go over them and delete at least
> half!) I assigned a keyboard shortcut to a lot of them.
>
> I seem to remember that before XL 2007, there was a keyboard organizer
> that I could go through and review what shortcuts I had already
> assigned to my macros. I can't find that in 2007, though.
>
> Is there an easy way to generate a list of all my keyboard assignments
> and what macros they go to?
>
> Ed


 | 
Pages: 1
Prev: Special character in Input Message - Data Validation
Next: UserForm1.ComboBox1 to initialize