How to create shortcut keys to xl 2007macros

Solved/Closed
Gowind - May 13, 2011 at 04:21 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 17, 2011 at 04:59 AM
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

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
May 13, 2011 at 04:41 AM
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
0
Hey Thank you very much.........
0
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
May 17, 2011 at 04:59 AM
You are Most welcome
0