That was too simple...LOL
I tried making it a Private Sub, renaming the box to Mail, etc..
Your site is now in my favorites.
Thanks alot Ron

"Ron de Bruin" wrote:

Hi Shinka

Enter only the macro name in the click event and copy the macro in a normal module

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Shinka" wrote in message ...
Very helpful, Thanks. I can use them if I attach it as a macro to a
'button'. Get errors if trying to insert it in a 'command button' between:

Private Sub CommandButton1_Click()

End Sub

What is the proper way to insert it?

"Ron de Bruin" wrote:

Hi Shinka

See
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Shinka" wrote in message ...
I put a command button on my spreadsheet and would like the code to email the
spreadsheet when clicked. Probably should save it too before mailing.

Thanks for you programming skills! :)