can you add a shortcut to a macro after it's been made
 

Sometimes i make macros without shortcut keys and later on find that I'd like
to have one. Is there a way to add one later?

can you add a shortcut to a macro after it's been made
 

rook, hit F8 to bring up the macro box, options, assign shortcut key from
there
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"rook" wrote in message
...
Sometimes i make macros without shortcut keys and later on find that I'd
like
to have one. Is there a way to add one later?

can you add a shortcut to a macro after it's been made
 

In my Excel97 it is alt-F8 and then you will need to select the "options"
button. From there, it should be fairly self-explanatory.

Christmas May



"Paul B" wrote:

rook, hit F8 to bring up the macro box, options, assign shortcut key from
there
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"rook" wrote in message
...
Sometimes i make macros without shortcut keys and later on find that I'd
like
to have one. Is there a way to add one later?