Run a macro shortcut from another macro?

  • Thread starter Thread starter George J
  • Start date Start date
G

George J

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
 
George

Consider using Application.Run to call it from the other workbook. You can
specify which workbook's macro to run.

Application.Run("Book1.xls!MyMacro")

MyMacro must be Public and in a standard module.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
How to force macros refer to ActiveWorkbook 2
Macro shortcuts are running macros in different open workbook 3
Macro for all Excel Workbooks to print to PDF 2
Run code from another workbook 7
Pasting cell contents into a macro 1
Run Macro on All Sheets Q 8
Macro doesn't execute fully using shortcut 6

Back
Top