You can just use Call but you need to reference the sheet.

Call Sheets("Sheet2").MySub
--
HTH...

Jim Thomlinson


"Greg H." wrote:

I have Sheet1 and Sheet2. There is a Public Sub on Sheet2 that sends out
emails based on data on Sheet2. I would like to be able to click a button on
Sheet1 and run the Public Sub on Sheet2. When i try to use Application.Run
"email" i get the error "Run-time error '1004': Applicaiton-defined or
object-defined error"

Any ideas?