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/

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/

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

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/

.