Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling a macro from Worksheet--Activate | Excel Discussion (Misc queries) | |||
CALLING MACROS FROM A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
calling macros from worksheet to another | Excel Discussion (Misc queries) | |||
calling worksheet function from a macro | Excel Worksheet Functions | |||
calling up information from a different worksheet. | Excel Worksheet Functions |