Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How to assign a shortcut key to my macro? Is there any way to directly assign it through VBA code?

share|improve this question

2 Answers 2

There's an SDK available for this commercial software from Chirag Dalal http://officeone.mvps.org/ppsctmgr/ppsctmgr.html

The SDK is here: http://officeone.mvps.org/ppsctmgr/ppsctmgr_sdk.html

share|improve this answer

This is also my problem today and buying an additional software just for this shortcut should not be reasonable. I found out that coding this in Autohotkey can actually work. This is a sample one that only need to press Ctrl+r and you can already run your macro. The prerequisite of course , you should have your macro in the custom tool bar button as addins.

LCtrl & r::
Send Raw{Alt}
SendRaw x
SendRaw y
Send Raw{Alt}
SendRaw h
Send Raw{Alt}
Goto, Exit

Hope this should help some guys who might have similar problems in the future.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.