Previous Topic Next Topic

How to create shortcut keys to xl 2007macros

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

Réponse 1 / 3
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
13 May 2011 à 04:41
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
Réponse 2 / 3
Gowind
17 May 2011 à 04:03
Hey Thank you very much.........
Réponse 3 / 3
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
17 May 2011 à 04:59
You are Most welcome