blocking cells from view in a spreadsheet

[Tini]

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?

 

[Ron de Bruin]

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

 

[dlw]

maybe just make a copy of the spreadsheet, delete the salary info, and send
that one?

 

[Tini]

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]

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