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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Greg H." wrote in message
...
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?