golf4
03-21-2006, 10:12 PM
Hi, guys -
:hi: :hi: :hi: YEA - YEA - YEA...... know I've been away for a while, but thought I'd hop back in with both feet...... GREAT TO BE BACK!!!!
I have a quick one for ya here. I continue working on my extensive income calculation spreadsheet for work. There is one worksheet that needs to be send directly to our Accounting people that staff continues to forget about. To resolve this, I'd like to set it up where the user uses a command button to email the individual worksheet directly to a specific Accounting person.
I found the code noted below that will send the workbook, but I'm wondering how I can modify it to send only the individual worksheet? I've tried changing "ActiveWorkbook" to "ActiveWorksheet", but no dice.
Option Explicit
Private Sub CommandButton1_Click()
ActiveWorkbook.SendMail jdoe@xxxxxx.org, "My Worksheet"
End Sub
Any help would be great!!!!
Thanks again for all the help.........
Golf
:hi: :hi: :hi: YEA - YEA - YEA...... know I've been away for a while, but thought I'd hop back in with both feet...... GREAT TO BE BACK!!!!
I have a quick one for ya here. I continue working on my extensive income calculation spreadsheet for work. There is one worksheet that needs to be send directly to our Accounting people that staff continues to forget about. To resolve this, I'd like to set it up where the user uses a command button to email the individual worksheet directly to a specific Accounting person.
I found the code noted below that will send the workbook, but I'm wondering how I can modify it to send only the individual worksheet? I've tried changing "ActiveWorkbook" to "ActiveWorksheet", but no dice.
Option Explicit
Private Sub CommandButton1_Click()
ActiveWorkbook.SendMail jdoe@xxxxxx.org, "My Worksheet"
End Sub
Any help would be great!!!!
Thanks again for all the help.........
Golf