The code create the workbook, send it and delete it so you still have one workbook.
It is always possible to read the data in the two columns if you hide it.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Tini" wrote in message ...
I could do that, but is there a way to keep from having 2 spreadsheets? I'd
like to keep it all on one sheet, if possible with 2 columns out of view. Do
you know if that's possible?

"Ron de Bruin" wrote:

Why not send a workbook with only the visisble data ?

If you want to mail see for example
http://www.rondebruin.nl/mail/folder1/mail4.htm

There is also a Outlook only example that have a few more options on my site


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Tini" wrote in message ...
I have a spreadsheet that I need to send to a large distribution, but 2 of
the columns have confidential salary information and I want those blocked
from view and locked. Is there a way to do this?