Can you prevent a protected range from being copied?

  • Thread starter Thread starter Rich Wallach
  • Start date Start date
R

Rich Wallach

Is there any way to prevent a protected range from being
copied into another workbook?
Thanks in advance,
Rich
 
I believe taht if you protect the workbook as well, you
will not be able to copy the workbook or any piece of it
into another workbook.
 
Thanks, I tried it, but that doesn't stop you from copying
from the protected workbook to another.
Rich
 
No, there is no easy way to block someone from copying protected cells.
You could write macros that would try to block copy operations, but the
bottom line is that XL was not designed for such purposes. Some
versions of XL2003 have 'IRM' capability, but I don't have any
experience with it.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Back
Top