Calling a macro in another worksheet
 

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?

Calling a macro in another worksheet
 

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.
-----Original Message-----
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?



.

Calling a macro in another worksheet
 

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"



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tolga" wrote in message ...
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?