Assing shortcut to macro using VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bo Rasmussen - 14 Sep 2005 09:45 GMT

Hi,

How do I setup a shortcut to a macro uisng VBA using Office '97.

Regards
Bo Rasmussen

Reply to this Message

Anne Troy - 14 Sep 2005 13:41 GMT

While not exactly the same, it's very similar to this:
http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_office_ap
plications.htm
************
Anne Troy
www.OfficeArticles.com

> Hi,
>
> How do I setup a shortcut to a macro uisng VBA using Office '97.
>
> Regards
> Bo Rasmussen

Reply to this Message

Bo Rasmussen - 15 Sep 2005 13:42 GMT

Hi Anne,

FYI I found this in the help for the Rebind command

This sets the shortcut Ctrl-Shift-5 to the macro documentSetup located in
the module1 module.

CustomizationContext = ActiveDocument
Set myKey = FindKey(BuildKeyCode(wdKeyControl, wdKeyShift, wdKey5))
myKey.Rebind KeyCategory:=wdKeyCategoryCommand,
Command:="module1.documentSetup"

Regards
Bo

> While not exactly the same, it's very similar to this:

http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_office_ap
plications.htm

> ************
> Anne Troy
[quoted text clipped - 6 lines]
> > Regards
> > Bo Rasmussen

Reply to this Message