dim otherworkbook as workbook

set otherworkbook = workbooks("yourothernamehere.xls")

application.run "'" & otherworkbook.name & "'!macronamehere"



Antonio wrote:

How do I run a sub that is declared as public in a different open workbook
(project)?

Thanks,

Antonio

--

Dave Peterson