Not possible pre excel 2002
http://support.microsoft.com/default...b;en-us;826920
Can you install an add-in?
http://www.rondebruin.nl/mail/add-in.htm
http://www.mvps.org/dmcritchie/excel/install.htm
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"Ash" wrote in message
...
I have a spreadsheet with several worksheets. The worksheet I want to
email to a co-worker, for example reads from 5 different worksheets of
the same spreadsheet. I would like to know a way to email only one
worksheet (tab) not the whole spreadsheet. I don't have or know VBA.
--
Ash