How do I print a specific worksheet everytime?
 

I have built a quoting program that uses 4 different worksheets (tabs on
bottom) and I would like to print the last worksheet every time I am
finished. Also if possible I would like to e-mail it as a .pdf (just the
last worksheet) to whomever I have done the quote for. I have adobe acrobat
so I can print as .pdf.

How do I print a specific worksheet everytime?
 

All you ever need to know about emailing from Excel can be found at Ron de
Bruin's site.

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

Note the free Sendmail Add-in to make your life easier.


Gord Dibben MS Excel MVP



On Mon, 10 May 2010 04:58:02 -0700, Trevor
wrote:

I have built a quoting program that uses 4 different worksheets (tabs on
bottom) and I would like to print the last worksheet every time I am
finished. Also if possible I would like to e-mail it as a .pdf (just the
last worksheet) to whomever I have done the quote for. I have adobe acrobat
so I can print as .pdf.