Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,173
Default Hot Keys

Check out the Onkey method, this re-purposes the built in Excel keys

Sub test()
'Re-puposes
Application.OnKey "^1", "MyCode"
End Sub

Sub myCode()
MsgBox "It ran with Ctrl+1"
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Inspector" wrote in message
...
I have a macro that I would like to fire by hitting the 'Control 1' keys.
How do I begin?

Thanks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable CUT via toolbars or shortcut keys sparx Excel Discussion (Misc queries) 0 April 30th 06 08:34 PM
my arrow keys don't work. bulkmailman Excel Discussion (Misc queries) 1 December 3rd 05 11:13 PM
Deactivate shortcut keys in excel.. areddy Excel Discussion (Misc queries) 1 October 25th 05 02:37 PM
Cursor Keys does not change cell focus Skypilot Excel Discussion (Misc queries) 3 February 24th 05 07:13 AM
How to make [toggling] shortcut keys to superscript and subscript, respectively? Mann Lee Excel Discussion (Misc queries) 8 December 13th 04 01:50 PM


All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"