Creating / Changing Keyboard Shortcuts for Macros in Add Ins

I have a slew of procedures I've created over the years that I store in an xlam Add In.  Some of them can be activated with keyboard shortcuts.  In Excel 2013, I can't seem to figure out how to change the shortcuts I created.  Do add in macros just not show up in the macro dialog interface?   Oddly, I can't find anything on the internet to answer this question.
shachoAsked:
Who is Participating?
 
shachoAuthor Commented:
Actually, I figured it out by tinkering around in the VBE.  I changed the "IsAddin" property of the add in's "ThisWorkbook" object to false, and it immediately became a live workbook with all its public procedures visible in the Marco dialog.  From there I was able to edit the shorcuts.  When finished I just changed the IsAddin property back to True and clicked save in the VBE.  All done.
0
 
Rory ArchibaldCommented:
No, routines in add-ins don't appear in the macros dialog - although you can type the routine name into the macro name part and it will then be available to run, or change the shortcuts.

It's usually easier to have a routine in the add-in that assigns the key combinations using Application.OnKey in the Workbook_Open event.
0
 
shachoAuthor Commented:
Solved independently
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.