ShortCut for macro through VB

[Shakeel Ahmad]

I we record a new macro, then we find an option with the keyboard shortcut.

but if i have created a macro through VB, then how can i make a shortcut key
to run that macro.

Thanks and Regards,

 

[Jonathan West]

I we record a new macro, then we find an option with the keyboard shortcut.

but if i have created a macro through VB, then how can i make a shortcut
key to run that macro.

Thanks and Regards,

Go to Tools, Customize. Click the Keyboard button on the dialog. In the
Categories listbox, select Macros, in the macros listbox, select your macro.
Press the shortcut key you want to assign - it will appear in the
appropriate box. Then click Assign, and then Close.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Shakeel Ahmad]

Whatever I asked here, I received a brief reply.

It is a great place to learn which I came to know very late, but now I am
learning very useful things from here.

Thanks and Regards
Shakeel