Is there a way I can change the shortcut key without having to redo the macro?

  • Thread starter Thread starter Christiane
  • Start date Start date
C

Christiane

Can I change a shortcut key in an excel macro without having to redo it?
 
Christiane,

Application.MacroOptions Macro:="MacroName", _
Description:="Macro by Excel-lent Christiane", _
ShortcutKey:="i"

HTH,
Bernie
MS Excel MVP
 
Alt+F8, select the macro then options, change the shortcut key

--
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 2000 & 97
** remove news from my email address to reply by email **
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have nearly run out of Shortcut Keys 4
How do I change the shortcut key for a macro 3
Button Click but not Shortcut Key 1
Assigning Keyboard Shortcuts after creating a macro. 2
Help changing Keyboard Shortcut assigned to Excel Macro 2
Assign macro to shortcut keys "ctrl + 1"? 2
Macro shortcuts are running macros in different open workbook 3
UNDO and REDO buttons are inactive 7

Back
Top