View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
George J George J is offline
external usenet poster
 
Posts: 14
Default 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