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?