Shortcuts: How to change them?

[beeawwb]

Good afternoon all.

I just made an XLA with a shortcut that I wanted to be available to m
(You may have seen my paste special question), and I set the shortcu
to Crtl-D in the workbook before I saved it as an XLA. Now I find out
Ctrl-D already was a shortcut, for copy the above cell. I want t
change my shortcut, without opening up and resaving the XLA.

So, my question is this. Where is the data about what key(s) are use
for a particular macro shortcut?

A side question related, but not important, is there a list of al
shortcuts keys available in Excel? I've tried the help file, but
can't get a list of everything available and what they do.

Thanks for the help.

-Bo

 

[Guest]

Press Alt+F8 to display the macro dialog box (or go to the tools menu --> macro --> macros), select the macro you want to change, click the options button and you should be able to see and change the shortcut key for the macro.

Hope this is the info you are looking for.

Brandt


Sorry, cant help on question #2

 

[beeawwb]

The problem is that I have it as an XLA Add-In, so it's not listed unde
the Macro Box.

-Bo

 

[David McRitchie]

For the second part of your question -- a list of builtin Excel shortcuts
taken from help all on one page see
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

The help separating out the shortcuts makes Help rather useless
the purpose of looking for builtin Excel shortcuts.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Dave Peterson]

But if you don't save the change, won't you have to do this each time you load
the addin--each time you open excel?????

If my addin's project were not protected, I could do:
tools|macro|macros...
type in the name:
personal.xla!mymacronamehere
then hit Options

but if the project were protected, the options button stayed disabled.

 

[beeawwb]

You know, I hadn't actually thought about that bit, saving the XLA. If
want the changes to be permanent, I need to recompile the xls as a
xla. *slaps forehead*

Thanks both of you, that list was a great help too.

-Bo