Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute a macro from another macro
hi,
how do i execute a macro fron another macro? They are in the same workbook, but in different worksheets! Thanks --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute a macro from another macro
Sub MyMacro()
Sheet1.OtherMacro End Sub -- Regards, "joao" wrote in message ... hi, how do i execute a macro fron another macro? They are in the same workbook, but in different worksheets! Thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute a macro from another macro
Macros on different modules of the same workbook are called exactly as if
they were in the same module - by their names: In Module1: Sub CallMod2Sub() Mod2Sub End Sub In Module2: Sub Mod2Sub() MsgBox "Hello from Module2" End Sub -- Jim Rech Excel MVP |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute a macro from another macro
Just put the name of the macro
Call macroname regards Km -----Original Message----- hi, how do i execute a macro fron another macro? They are in the same workbook, but in different worksheets! Thanks --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Execute Macro | Excel Discussion (Misc queries) | |||
Auto Execute Macro | Excel Worksheet Functions | |||
Auto-execute macro.... | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Execute Macro | Excel Discussion (Misc queries) |