Calling a macro in another worksheet

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?
 
F

Frank Stone

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.
 
R

Ron de Bruin

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"
 
Top