data validation question

A

al

Hi,

Recently I came upon this problem and don't know how to solve it. I
have a worksheet in which I have data validation set for a list of
choices, It gives you an error message if anything other than the
string selected from the list is entered from Keyboard, which its
suppose to, however if I copy and paste anything different than my
list it accepts it and I loose all my data validation listing for
those cells.

I do not want people manipulating my data as it will be shared with
other people, and I do not want to lock my worksheet to protection
mode since there will be corrections, manipulations etc..

Any idea how can I achieve this?? Or is this a bug in MSFT??

Thanks for the help,
 
J

Jim

No matter the validation setting, data can be pasted in so long as the
cell(s) can be selected.
 
M

Mark Graesser

Al,
You will need to set up some level of protection. This is under Tools>Protection>Protect_Sheet. You can find some info in the help files, search on "worksheet protection". You will need to format each cell as locked or unlocked.

Regards,
Mark Graesser
[email protected]

----- al wrote: -----

Hi,

Recently I came upon this problem and don't know how to solve it. I
have a worksheet in which I have data validation set for a list of
choices, It gives you an error message if anything other than the
string selected from the list is entered from Keyboard, which its
suppose to, however if I copy and paste anything different than my
list it accepts it and I loose all my data validation listing for
those cells.

I do not want people manipulating my data as it will be shared with
other people, and I do not want to lock my worksheet to protection
mode since there will be corrections, manipulations etc..

Any idea how can I achieve this?? Or is this a bug in MSFT??

Thanks for the help,
 
Top