Preventing Copy-command

[Guest]

How can I disable Copy-command in a sheet (or whole workbook). I have a
protected sheet that includes hidden columns (data which users are not
allowed to see), but if you copy the area to a new sheet, then all hidden
data become visible.

Any ideas?

 

[Guest]

Hi,

This excellent code from Ken Puls does that but remember if macros are
disabled on startup then it doesn't work. If your data are that sensitive
then the only safe way is don't send it.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Mike

 

[Guest]

Thank You for a quick answer. That example really helped me. Disabling macros
is not a problem, because I have all the data in a database and you need
macros to read the data.

 

[Ron de Bruin]

Send only the visible data or send a pdf

For example
http://www.rondebruin.nl/mail/folder1/mail4.htm

 

[Guest]

I guess a false sense of security is better than no sense of security at all
<g>.