| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a way I can change the shortcut key without having to redo the macro?
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shortcut has change or move so this shortcut can not open | Excel Worksheet Functions | |||
| Change View,Zoom as shortcut key? | Excel Discussion (Misc queries) | |||
| How do i change the shortcut key for a macro? | Excel Discussion (Misc queries) | |||
| What is the shortcut keys to change between worksheets? | Excel Discussion (Misc queries) | |||
| shortcut key to change font color? | Excel Discussion (Misc queries) | |||
![Christiane[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
