Re: How do I prevent data i a cell from being copied?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I don't think you will find a way to do this.

You can lock the cells and protect the *** with no selection of locked or
unlocked cells cells so users cannot select to copy but.....................

User can enter =Sheet1A1 on another sheet and get the contents.


Gord Dibben MS Excel MVP

On Thu, 4 Sep 2008 01:36:01 -0700, Bo J Eriksson <Bo J
Eriksson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I want to prevent data from some cells in my work*** not to be copied to
other worksheets. There are possibilities to hide and protect data not to be
changed in a work***, but I do not find a way to prevent the data to be
copied to another work***.

.


Quantcast