Thanks for your response Toppers. One more question please.
How do you undo what my first question was if I uncheck the box?

Robb

"Toppers" wrote:

Hi,
Look at Ron de Bruin's site which has an add-in for E-mailing
workbooks/worksheets.

http://www.rondebruin.nl/mail/add-in.htm

HTH

"Robb27" wrote:

Toppers,

It worked! (of course it did)
Many thanks!

Now, If you could give me one more that would allow a user to click a radio
button and email a just a particular sheet...not the entire workbook, that
would be cool!
Thanks again for your valuable time.

"Toppers" wrote:

Rob,

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Worksheets("Sheet1").Range("C1:C10").Copy Worksheets("Sheet2").Range("G1")
End If
End Sub

HTH

"Robb27" wrote:

I made a checkbox but I need to know how to make it when checked, it will
copy a range of cells to another sheet in the same workbook. Can anyone give
me a sample to get me started? Thanks in advance.

Rob