Emailing ONE WORKSHEET not ENTIRE FILE in Office 2007

[Guest]

We use to have an option to email current worksheet only or entire file in
the older Excel. That option window no longer pops up when I attempt to send
the current worksheet in Excel 07. How can I accomplish this?

 

[Ron de Bruin]

You can add this option to the QAT

The name is "Send to Mail Recipient"
Search for it in the commands that are not in the ribbon list

See
http://www.rondebruin.nl/0307commands.htm

For mail code or a Add-in see
http://www.rondebruin.nl/sendmail.htm