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

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


---
Message posted from http://www.ExcelForum.com/

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

Christiane,

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

HTH,
Bernie
MS Excel MVP


"Christiane " wrote in message
...
Can I change a shortcut key in an excel macro without having to redo it?


---
Message posted from http://www.ExcelForum.com/

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

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 **
"Christiane " wrote in message
...
Can I change a shortcut key in an excel macro without having to redo it?


---
Message posted from http://www.ExcelForum.com/

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

Excellent!

Thank you

--
Message posted from http://www.ExcelForum.com

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

By the way Bernie, are you implying I am slow?
;)
Christian

--
Message posted from http://www.ExcelForum.com