Thread: Rund VB code on one tab while on another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg H.[_3_] Greg H.[_3_] is offline
external usenet poster
  
Posts: 30
Default Rund VB code on one tab while on another
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?
Reply With QuoteReply With Quote