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?

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

"djExcel" wrote:

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?

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.

"Mike H" wrote:

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

"djExcel" wrote:

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?

Send only the visible data or send a pdf

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


--

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


"djExcel" wrote in message ...
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.

"Mike H" wrote:

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

"djExcel" wrote:

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?

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

--
Regards,
Tom Ogilvy


"djExcel" wrote:

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.

"Mike H" wrote:

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

"djExcel" wrote:

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?