Is it possible to send a worksheet without the unhidden data?
 

I am trying to send a worksheet to someone, but do not want them to see what
I have hidden. Is it possible to only copy the visible cells?

Mnree7 -

I am trying to send a worksheet to someone, but do not want them to see
what I have hidden. Is it possible to only copy the visible cells? <

Select the range containing the visible cells.

Edit | Go To | Special | Visible Cells Only | OK.

Edit | Copy.

Select some other cell.

Edit | Paste.

- Mike

www.mikemiddleton.com

Try this
http://www.rondebruin.nl/mail/folder1/mail4.htm

Or use my SendMail Add-in
http://www.rondebruin.nl/mail/add-in.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mnree7" wrote in message ...
I am trying to send a worksheet to someone, but do not want them to see what
I have hidden. Is it possible to only copy the visible cells?