How to create shortcut keys to xl 2007macros [Solved/Closed]

Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hi,

I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is their to assign shortcut with Crtl + Key combination.But i want Ctrl + Shift + Key combition.Is it possible .plz any body help me.


Thanks,
Gowind

3 replies

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
118
Yes It is possible,

click on the box next to ctrl in shortcut key option,
now press Shift + Key,
now your shortcut key is:
Ctrl + Shift + key
Hey Thank you very much.........
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
118
You are Most welcome

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!