Calling a macro in another worksheet

  • Thread starter Thread starter Tolga
  • Start date Start date
T

Tolga

Hi,

With a macro in an WORKSHEET A, I would like to open
WORKSHEET B, then in the macro in Worksheet A, I would
like to start the macro in worksheet B. Call function
works for the macros in the same worksheet but for
another worksheet what code should I use?
 
A macro on sheet A in for sheet A only. you can try to
move your macro from sheet A to thisworkbook. I think it
will work there.
 
Hi Tolga

Use Application.run to call a macro in a other open workbook
Some notes on this from Chip Pearson

Application.Run "Book1.xls!MacroName"

Or, if the book name contains spaces, (watch the quotes)

Application.Run "'Book One.xls'!MacroName"
 
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

How to call module function or sub from the Add In? 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2013 Merge Data 2
macro to control tabs (different worksheets) 8
How to force macros refer to ActiveWorkbook 2
Need Macro... 8
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Run Macro If Cell have "x" value 0

Back
Top