Excel 2007 : eMailing Worksheet

[mocco]

I have designed a worksheet which contains 3 drop down lists.

The tables for these drop downs are located on 3 seperate pages in the same workbook.

When I select 'email as PDF attatchement' all pages are shown including the tables.

I only want the spreadsheet to be emailed.

How can I achieve this please??

Chris.

[pike]

Hi mocco,
Can you attach a small sample workbook?

[mocco]

Bump, bump, bump

[pike]

Hey mocco,
worked out how to attach the workbook?

[pike]

Hi mocco,
What code are you using to create the email?