I notice that if I set Data Validation I cannot stop a user from copying over
the cell from another cell outside the validation range and breaking the
validation of the cell copied over. Then on another note if the user copies
a cell from a different file it will accept the input but will keep the
original validation parameters with potentially incorrect data that does not
fit the original validation.

My first thought was to protect the worksheet and limit access to only
unprotected cells. But that is not even close to being a solution because
the user will have many unprotected cells they could copy from and / or could
open a different file and copy from it.

This is causing major problem. Is there a way to make the cell hold the
original validation and test the validation regardless of where the copy is
coming from?

Thank you for your help.

Steven

Don't let them copy. You can disable <Ctrl<V, as well as the Paste
function, and then enable it on closing the worksheet

"Steven" wrote:

I notice that if I set Data Validation I cannot stop a user from copying over
the cell from another cell outside the validation range and breaking the
validation of the cell copied over. Then on another note if the user copies
a cell from a different file it will accept the input but will keep the
original validation parameters with potentially incorrect data that does not
fit the original validation.

My first thought was to protect the worksheet and limit access to only
unprotected cells. But that is not even close to being a solution because
the user will have many unprotected cells they could copy from and / or could
open a different file and copy from it.

This is causing major problem. Is there a way to make the cell hold the
original validation and test the validation regardless of where the copy is
coming from?

Thank you for your help.

Steven

Thanks for the repsponse. But on some things I will want them to be able to
copy.

I thought there might be something about protecting Data / Validation cells
that unless the cell being copied has the same validation setup it cannot be
copied to it.

"kassie" wrote:

Don't let them copy. You can disable <Ctrl<V, as well as the Paste
function, and then enable it on closing the worksheet

"Steven" wrote:

I notice that if I set Data Validation I cannot stop a user from copying over
the cell from another cell outside the validation range and breaking the
validation of the cell copied over. Then on another note if the user copies
a cell from a different file it will accept the input but will keep the
original validation parameters with potentially incorrect data that does not
fit the original validation.

My first thought was to protect the worksheet and limit access to only
unprotected cells. But that is not even close to being a solution because
the user will have many unprotected cells they could copy from and / or could
open a different file and copy from it.

This is causing major problem. Is there a way to make the cell hold the
original validation and test the validation regardless of where the copy is
coming from?

Thank you for your help.

Steven

Not as far as I know, but maybe one of the MVP's can come to your rescue.

"Steven" wrote:

Thanks for the repsponse. But on some things I will want them to be able to
copy.

I thought there might be something about protecting Data / Validation cells
that unless the cell being copied has the same validation setup it cannot be
copied to it.

"kassie" wrote:

Don't let them copy. You can disable <Ctrl<V, as well as the Paste
function, and then enable it on closing the worksheet

"Steven" wrote:

I notice that if I set Data Validation I cannot stop a user from copying over
the cell from another cell outside the validation range and breaking the
validation of the cell copied over. Then on another note if the user copies
a cell from a different file it will accept the input but will keep the
original validation parameters with potentially incorrect data that does not
fit the original validation.

My first thought was to protect the worksheet and limit access to only
unprotected cells. But that is not even close to being a solution because
the user will have many unprotected cells they could copy from and / or could
open a different file and copy from it.

This is causing major problem. Is there a way to make the cell hold the
original validation and test the validation regardless of where the copy is
coming from?

Thank you for your help.

Steven

No. That is a limitation of Validation. It is handled almost the same as a
format. Also, validation will not examine an entry already in a cell. Only
while it is being entered manually (by editing the cell).



--
Regards,
Tom Ogilvy


"Steven" wrote in message
...
Thanks for the repsponse. But on some things I will want them to be able
to
copy.

I thought there might be something about protecting Data / Validation
cells
that unless the cell being copied has the same validation setup it cannot
be
copied to it.

"kassie" wrote:

Don't let them copy. You can disable <Ctrl<V, as well as the Paste
function, and then enable it on closing the worksheet

"Steven" wrote:

I notice that if I set Data Validation I cannot stop a user from
copying over
the cell from another cell outside the validation range and breaking
the
validation of the cell copied over. Then on another note if the user
copies
a cell from a different file it will accept the input but will keep the
original validation parameters with potentially incorrect data that
does not
fit the original validation.

My first thought was to protect the worksheet and limit access to only
unprotected cells. But that is not even close to being a solution
because
the user will have many unprotected cells they could copy from and / or
could
open a different file and copy from it.

This is causing major problem. Is there a way to make the cell hold
the
original validation and test the validation regardless of where the
copy is
coming from?

Thank you for your help.

Steven