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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Prevent unhiding columns 1
Protect "Copy" and "Save As" changes to workbook 3
How do I prevent data i a cell from being copied? 2
Pasting to Protected Cells in Xl2000 3
Excel Move or Copy Stopped Working? 0
Copy Command 1
Locking Down Workbooks Properly & Disabling Functionality 2

Back
Top