how do I set a button in a sprdsheet to email that sprdsheet to me
 

I am writing a website. I have a link that opens an Excell spreadsheet. I
need the user to be able to enter some data and click a button field with a
hyperlink that will email the entire worksheet to me

how do I set a button in a sprdsheet to email that sprdsheet to me
 

Hi Chuck

I use this code for sending an E-Mailed sheet to me.

Sub Email()
ActiveWorkbook.SendMail "E-mail Name"
MsgBox "This completed form has been sent to name"
End Sub

You can then put a button on the screen and assign this macro to it.

Regards
Michael M

"chuck" wrote:

I am writing a website. I have a link that opens an Excell spreadsheet. I
need the user to be able to enter some data and click a button field with a
hyperlink that will email the entire worksheet to me