Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
Hi,
Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
Highlight the macro in Tools=Macro=Macros and hit the Options button.
Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
Hi Tom,
Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
Try recording a macro for this.
"John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
Application.MacroOptions Macro:="DoRand", _
HasShortcutKey:=True, ShortcutKey:="Z"as an example. -- Regards,Tom Ogilvy"John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
Max,
Thanks, very sensible of course! The result is this: Sub ChangeShortCut() Application.MacroOptions Macro:="Macro3", _ ShortcutKey:="T" End Sub This I guess leads to another question.............how would I go about "reading" (printing) a list of all existing macro shortcuts? Thanks again John "Max Potters" wrote in message ... Try recording a macro for this. "John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
There is no such list available.
-- Regards, Tom Ogilvy "John" wrote in message ... Max, Thanks, very sensible of course! The result is this: Sub ChangeShortCut() Application.MacroOptions Macro:="Macro3", _ ShortcutKey:="T" End Sub This I guess leads to another question.............how would I go about "reading" (printing) a list of all existing macro shortcuts? Thanks again John "Max Potters" wrote in message ... Try recording a macro for this. "John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
Hi John,
Im glad that helped you, but I dont really understand what you mean about "reading" (printing) a list of all existing macro shortcuts. Do you mean, that you would like to know which shortcuts are already in use? Max "John" wrote in message ... Max, Thanks, very sensible of course! The result is this: Sub ChangeShortCut() Application.MacroOptions Macro:="Macro3", _ ShortcutKey:="T" End Sub This I guess leads to another question.............how would I go about "reading" (printing) a list of all existing macro shortcuts? Thanks again John "Max Potters" wrote in message ... Try recording a macro for this. "John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
Sorry maybe I being too short in the details. What I'm trying to do is
program a set of programable keys (www.x-keys.com**) to fire various macros within an Excel application. You've both helped out with the assigning shortcut keys, but what I was hoping to do is to assign something like a "key code" (ie CTRL+SHIFT+1+2+3) so that it does pick up another incorrect shortcut by mistake. The only other complication is that I want the users (who have German / French keyboard layouts) to be able to use the same sequences (hence the desire for a key code). I guess I could write a quick procedure that would run when the workbook was opened, assigning the correct shortcuts to the macros within the workbook? What do you both think? Can you recommend a better approach? Thanks to you both John **The X-Keys keypad works by assigning any combination of keystrokes to a particular programable key. "Max Potters" wrote in message ... Hi John, Im glad that helped you, but I dont really understand what you mean about "reading" (printing) a list of all existing macro shortcuts. Do you mean, that you would like to know which shortcuts are already in use? Max "John" wrote in message ... Max, Thanks, very sensible of course! The result is this: Sub ChangeShortCut() Application.MacroOptions Macro:="Macro3", _ ShortcutKey:="T" End Sub This I guess leads to another question.............how would I go about "reading" (printing) a list of all existing macro shortcuts? Thanks again John "Max Potters" wrote in message ... Try recording a macro for this. "John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
John, Im working on a solution for you, it might take me a while, but ill
post it later Max "John" wrote in message ... Sorry maybe I being too short in the details. What I'm trying to do is program a set of programable keys (www.x-keys.com**) to fire various macros within an Excel application. You've both helped out with the assigning shortcut keys, but what I was hoping to do is to assign something like a "key code" (ie CTRL+SHIFT+1+2+3) so that it does pick up another incorrect shortcut by mistake. The only other complication is that I want the users (who have German / French keyboard layouts) to be able to use the same sequences (hence the desire for a key code). I guess I could write a quick procedure that would run when the workbook was opened, assigning the correct shortcuts to the macros within the workbook? What do you both think? Can you recommend a better approach? Thanks to you both John **The X-Keys keypad works by assigning any combination of keystrokes to a particular programable key. "Max Potters" wrote in message ... Hi John, Im glad that helped you, but I dont really understand what you mean about "reading" (printing) a list of all existing macro shortcuts. Do you mean, that you would like to know which shortcuts are already in use? Max "John" wrote in message ... Max, Thanks, very sensible of course! The result is this: Sub ChangeShortCut() Application.MacroOptions Macro:="Macro3", _ ShortcutKey:="T" End Sub This I guess leads to another question.............how would I go about "reading" (printing) a list of all existing macro shortcuts? Thanks again John "Max Potters" wrote in message ... Try recording a macro for this. "John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
John,
I think i have found something for you. When the workbook opens, I putted code there which makes sure that on certain macro's, a shortcut key is assigned, like you wanted ctrl+shift+1 for example.* You can change this code easily, and if you have questions about the attachment ask me. I will send it to your email address, so mind to check your spam folder (if you have any). This attachment will be called "John" Hope this helpes, please reply if it's ok. Regards Max (16) the netherlands "Max Potters" wrote in message ... John, Im working on a solution for you, it might take me a while, but ill post it later Max "John" wrote in message ... Sorry maybe I being too short in the details. What I'm trying to do is program a set of programable keys (www.x-keys.com**) to fire various macros within an Excel application. You've both helped out with the assigning shortcut keys, but what I was hoping to do is to assign something like a "key code" (ie CTRL+SHIFT+1+2+3) so that it does pick up another incorrect shortcut by mistake. The only other complication is that I want the users (who have German / French keyboard layouts) to be able to use the same sequences (hence the desire for a key code). I guess I could write a quick procedure that would run when the workbook was opened, assigning the correct shortcuts to the macros within the workbook? What do you both think? Can you recommend a better approach? Thanks to you both John **The X-Keys keypad works by assigning any combination of keystrokes to a particular programable key. "Max Potters" wrote in message ... Hi John, Im glad that helped you, but I dont really understand what you mean about "reading" (printing) a list of all existing macro shortcuts. Do you mean, that you would like to know which shortcuts are already in use? Max "John" wrote in message ... Max, Thanks, very sensible of course! The result is this: Sub ChangeShortCut() Application.MacroOptions Macro:="Macro3", _ ShortcutKey:="T" End Sub This I guess leads to another question.............how would I go about "reading" (printing) a list of all existing macro shortcuts? Thanks again John "Max Potters" wrote in message ... Try recording a macro for this. "John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Shortcut Key Programatically
John, do you have another email address? I keep getting messages that my
accachment couldnt be delivered. PLease give me another address.. Max "Max Potters" wrote in message ... John, I think i have found something for you. When the workbook opens, I putted code there which makes sure that on certain macro's, a shortcut key is assigned, like you wanted ctrl+shift+1 for example.* You can change this code easily, and if you have questions about the attachment ask me. I will send it to your email address, so mind to check your spam folder (if you have any). This attachment will be called "John" Hope this helpes, please reply if it's ok. Regards Max (16) the netherlands "Max Potters" wrote in message ... John, Im working on a solution for you, it might take me a while, but ill post it later Max "John" wrote in message ... Sorry maybe I being too short in the details. What I'm trying to do is program a set of programable keys (www.x-keys.com**) to fire various macros within an Excel application. You've both helped out with the assigning shortcut keys, but what I was hoping to do is to assign something like a "key code" (ie CTRL+SHIFT+1+2+3) so that it does pick up another incorrect shortcut by mistake. The only other complication is that I want the users (who have German / French keyboard layouts) to be able to use the same sequences (hence the desire for a key code). I guess I could write a quick procedure that would run when the workbook was opened, assigning the correct shortcuts to the macros within the workbook? What do you both think? Can you recommend a better approach? Thanks to you both John **The X-Keys keypad works by assigning any combination of keystrokes to a particular programable key. "Max Potters" wrote in message ... Hi John, Im glad that helped you, but I dont really understand what you mean about "reading" (printing) a list of all existing macro shortcuts. Do you mean, that you would like to know which shortcuts are already in use? Max "John" wrote in message ... Max, Thanks, very sensible of course! The result is this: Sub ChangeShortCut() Application.MacroOptions Macro:="Macro3", _ ShortcutKey:="T" End Sub This I guess leads to another question.............how would I go about "reading" (printing) a list of all existing macro shortcuts? Thanks again John "Max Potters" wrote in message ... Try recording a macro for this. "John" wrote in message ... Hi Tom, Thanks for this. I'm aware of this manual method, but was wondering if there is a way of doing this programatically? Best regards John "Tom Ogilvy" wrote in message ... Highlight the macro in Tools=Macro=Macros and hit the Options button. Make the assignment there. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, Does anyone know if you can change a macro's shortcut key programatically? If for instance I've already assign a macro to fire on CTRL+SHIFT+E, how could I change it to fire on say CRTL+SHIFT+T instead? Have a good weekend John |
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 | |||
How do i change the shortcut key for a macro? | Excel Discussion (Misc queries) | |||
How can I programatically change photos in one worksheet | Excel Discussion (Misc queries) | |||
How can I programatically change the language in the language bar? | Excel Discussion (Misc queries) | |||
Change Icon of a Shortcut with VBA? | Excel Programming |