PC Review


Reply
Thread Tools Rate Thread

Assign Shortcuts

 
 
Boss
Guest
Posts: n/a
 
      24th Nov 2008
Hi,

If I have ten different macros …

I need to assign shortkeys Ctrl 1, Ctrl 2 …. Crl 10 to the macors…

Please help me solve this...

Thanks!

 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      24th Nov 2008
Shortcut keys must be letters.
--
Gary''s Student - gsnu200815
 
Reply With Quote
 
Mike H
Guest
Posts: n/a
 
      24th Nov 2008
Hi,

Tools|Options|Macros

Navigate to your macro in the window and select it. Click 'Options' and
assign your shortcut.

Mike

"Boss" wrote:

> Hi,
>
> If I have ten different macros …
>
> I need to assign shortkeys Ctrl 1, Ctrl 2 …. Crl 10 to the macors…
>
> Please help me solve this...
>
> Thanks!
>

 
Reply With Quote
 
Boss
Guest
Posts: n/a
 
      24th Nov 2008
I wish to do it using number...

I can do it using keypad number but cannot using numpad number...

using code

Application.OnKey "^1", "Mymacro"


Thanks!

Boss
"Gary''s Student" wrote:

> Shortcut keys must be letters.
> --
> Gary''s Student - gsnu200815

 
Reply With Quote
 
Gary''s Student
Guest
Posts: n/a
 
      24th Nov 2008
Sub macro6()
Application.OnKey "^{END}", "hello"
End Sub

will work on the numeric keypad, but only with NUMLOCK off.
--
Gary''s Student - gsnu200815


"Boss" wrote:

> I wish to do it using number...
>
> I can do it using keypad number but cannot using numpad number...
>
> using code
>
> Application.OnKey "^1", "Mymacro"
>
>
> Thanks!
>
> Boss
> "Gary''s Student" wrote:
>
> > Shortcut keys must be letters.
> > --
> > Gary''s Student - gsnu200815

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign keyboard shortcuts Ms Microsoft Excel Worksheet Functions 0 26th Jan 2009 12:59 AM
Assign different keyboard shortcuts wal Microsoft Excel Programming 4 26th Oct 2008 11:26 PM
How do I assign keyboard shortcuts myself? eg Keep with next? kt Microsoft Word New Users 15 25th Aug 2008 09:56 PM
Is it possible to assign keyboard shortcuts of my own? kang Microsoft Powerpoint 3 11th Jun 2007 10:42 AM
Assign shortcuts to multiple documents John Microsoft Word Document Management 2 31st Aug 2004 07:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:53 PM.