I have used

I get:

Run-time error '1004':

The macro 'myworkbook.xls!kill_max_min' cannot be found.

In myworkbook I have

Public Sub kill_max_min()

Application.OnTime runwhen, "max_min", , False

End Sub


What am I doing wrong?

Thanks,

Antonio

"Don Guillett" wrote:

try
application.run otherworkbook.xls!mymacro

--
Don Guillett
SalesAid Software

"Antonio" wrote in message
...
How do I run a sub that is declared as public in a different open
workbook
(project)?

Thanks,

Antonio