I have an Excel 2007 macro that can be invoked from two different Shortcut Key methods. (1) Ctrl+Shift+N (2) Ctrl+Shift+P.
In VBA, is there a way to identify from which method the macro was invoked, that is (1) or (2) ?
I want to take different action in the macro based on how it was invoked..
In VBA, is there a way to identify from which method the macro was invoked, that is (1) or (2) ?
I want to take different action in the macro based on how it was invoked..