How do I call a sub from a different workbook? Can it be private?

No it mus be public and in a standrad code modele

Use

Application.Run "book2.xls!test_msgbox"

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"MikeH2" wrote in message
...
How do I call a sub from a different workbook? Can it be private?

Bob, interestingly Private subs are callable by Run.
Run seems not to play by the rules, so to speak.

--
Tim Zych
SF, CA

"Bob Phillips" wrote in message
...
No it mus be public and in a standrad code modele

Use

Application.Run "book2.xls!test_msgbox"

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"MikeH2" wrote in message
...
How do I call a sub from a different workbook? Can it be private?

Hi Tim,

So it does. That will teach me to assume.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNET wrote in message
...
Bob, interestingly Private subs are callable by Run.
Run seems not to play by the rules, so to speak.

--
Tim Zych
SF, CA

"Bob Phillips" wrote in message
...
No it mus be public and in a standrad code modele

Use

Application.Run "book2.xls!test_msgbox"

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"MikeH2" wrote in message
...
How do I call a sub from a different workbook? Can it be private?