ExcelBanter - How can I email one worksheet in a workbook, not the whole file?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I email one worksheet in a workbook, not the whole file? (https://www.excelbanter.com/excel-discussion-misc-queries/143191-how-can-i-email-one-worksheet-workbook-not-whole-file.html)

DLO

How can I email one worksheet in a workbook, not the whole file?

In excel 2003 I was able to email ony one worksheet from within a workbook.
Excel 2007 does not seem to give that option. Am i missing something?

All times are GMT +1. The time now is 04:56 AM.