email one sheet

[bb]

I would like to email sheet 3 as an attachment. I saved it in Word. When I
attach sheet 3 to the email, it looks as if the reipient can also open
sheets 1 and 2. Is this correct? If so, how can I prevent that from
happening?
TIA babs

 

[Norman Harker]

Hi bb!

Best and easiest way is to download Ron de Bruin's SendMail Addin and User
Guide from:

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

You'll find that SendMail gives you a large range of options including
sending 1 sheet with formulas or with current values.

But you can copy the sheet to a new workbook and send that
Or
Save as a new workbook and delete the other 2 sheets

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[chrisn]

What you can do is copy "Sheet 3" to a new book and send that.

1. Right click on the tab for "Sheet 3" (or what you have it named).

2. Click on "Move or Copy" a window will pop up with a drop down,
scroll list and a check box next to "Create a copy".

3. Click to put a check in "Create a Copy".

4. Click the drop down and select "(new book)".

5. Click "Ok".

This will create a copy of the spreadsheet in a new workbook which yo
can save and send as an attachment. The other pages will not b
included in the new workbook.

***CAUTION: If you have equations in the page you are copying, yo
might want to select the whole pages contents and right click to cop
it, then right click again to "paste Special" and click on "values"
That will post the information as it is and not as an equation relyin
on information in a separate workbook.****

Let me know how that works for you, I will be able to check back late
if you have any problems.

Chri

 

[bb]

Thanks so much; worked great!