I believe something like this is what he means....("a4") would be the cell that your e-mail address is in that you want the workbook sent to...or you could hide it way over in cell "aa4" or anywhere...copy and paste this into a module in your workbook.
Sub sendmail()
ActiveWorkbook.sendmail Recipients:=Range("a4")
End Sub
Then you need to put this in your "sheet1"
Private Sub CommandButton1_Click()
sendmail
End Sub
This of course is assuming you created a command button on your worksheet...and then put your e-mail address in cell a4 in sheet1 to test it out...
Sorry if this isn't very clear, I'm not very good at explaining....:-/