Run a macro shortcut from another macro?
I use Ctrl+n to run a macro
I now need to run this macro from another macro.
Tried using SendKeys "^%n", Wait:=True
but this didn't work. I cannot directly reference the
macro as there may be another workbook open (as
thisworkbook) that contains the same macro name but works
slightly differently - but if CTRL+n is pressed i have set
it up so that the macro from the activeworkbook will run.
can anyone help?
thanks
George
|