data validation question

  • Thread starter Thread starter al
  • Start date Start date
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,
 
No matter the validation setting, data can be pasted in so long as the
cell(s) can be selected.
 
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
(e-mail address removed)

----- 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,
 
Back
Top