Engineer Joe
Well-known Member
- Joined
- Jun 10, 2005
- Messages
- 549
I recently changed companies and couldn't take my Addin with me, but in my previous Addin, I had nearly every letter on the keyboard associated with a CNTRL+SHFT+<Shortcut Key>. I've rebuilt the most important of the shortcut keys and obviously, having used them thousands of times, it was easy to do from memory. However, I've noticed certain shortcut keys don't work anymore for one reason or another. The macro itself executes flawlessly, but the shortcut key combination doesn't call it. A good example is CNTRL+SHFT+P. In my new version of Excel (2016), it now pulls up the "Format Cells" menu, which is endlessly frustrating. Which leads me to my question.
Is there a way to circumvent/override the new default shortcut combos while still using the Macrooptions Shortcutkey method? If not, should I resort to using Onkey, and will that even work? If I do resort to the Onkey method, are there any pitfalls/disadvantages to using that method? My plan is just to change them out in the very same locations they exist now: In the WB_Open and WB_Close events of my Addin.
Any input or advise is welcome.
Is there a way to circumvent/override the new default shortcut combos while still using the Macrooptions Shortcutkey method? If not, should I resort to using Onkey, and will that even work? If I do resort to the Onkey method, are there any pitfalls/disadvantages to using that method? My plan is just to change them out in the very same locations they exist now: In the WB_Open and WB_Close events of my Addin.
Any input or advise is welcome.
