Add email attachment to command button

S

Shinka

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! :)
 
S

Shinka

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?
 
R

Ron de Bruin

Hi Shinka

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

Shinka

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
 
Top