Rund VB code on one tab while on another

G

Greg H.

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?
 
J

Jim Thomlinson

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

Call Sheets("Sheet2").MySub
 
J

Jon Peltier

You should probably move the procedure to a regular code module, not a class
module (the sheet modules are class modules attached to the sheets). Then
you can easily call it from anywhere.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to activate Sheet2? 5
Run-time error for objects deletion 2
range name define on non active(focused) sheet 10
Run-time error 1004 8
Excel VBA help: Text file formatting 19
Can I send an email too? 3
error; " 'Range' of object '_Worksheet' failed"? 2
copying cell comment from one sheet to another 2

Top