I set keyboard shortcuts for my personal.xls macros using iterations of application.onkey in the workbook_open event. (NB mods, have avoided code tags to make sentence readable).
I don't simply set shortcuts via the "macros" pop-out menu as i like to use different combinations of Ctrl, Shift & Alt... unless I'm mistaken the pop-out menu doesn't give that degree of flexibility (happy to be corrected).
That is because that is what I learned first, not because I have a clever reason for it.
Recently, I have come across macrooptions - corresponding to the macro options dialgoue box, which I understand I could use to set shortcuts in almost exactly the same way. My question is, should I?
Application.onkey feels "tacky" whilst macrooptions feels more "inbuilt" (robust?) but feelings like this are weak reasons for any kind of decision, particularly knowing that Excel is often fairly quirky (read: "backwards") when it comes to "the best way". Also, setting onkeys on open could be seen as overkill - but then perhaps it's more editable than a run-once assignment of macro shortcuts...?
Input gratefully received.
CC
Bookmarks