Shortcuts: How to change them?

B

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
 
B

Brandt

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
 
B

beeawwb

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

-Bo
 
D

David McRitchie

D

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.
 
B

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
 
Top