P
pepps
I have a spreadsheet that is used to collect information, ie, a for
with data entry fields. I lock all the fields that should not change
and protect the worksheet. I have data validation for numeric fields a
"whole number, greater than or equal to 0". However, if the user paste
a green background with .8 thick lines, it will paste numeric only data
but mess up the color and border formatting. The only thing the use
can do is "Select locked cells" or "Select unlocked cells". The Selec
locked cells is checked because I use the "Comments" as mouse-ove
pop-up instructions.
This works great except that I can't stop people from pasting into th
fields that are not locked. I would be fine if they pasted/value only
Does anyone know a way in VB to ensure that ALL pastes to a workshee
automatically and only use Paste/Value feature
with data entry fields. I lock all the fields that should not change
and protect the worksheet. I have data validation for numeric fields a
"whole number, greater than or equal to 0". However, if the user paste
a green background with .8 thick lines, it will paste numeric only data
but mess up the color and border formatting. The only thing the use
can do is "Select locked cells" or "Select unlocked cells". The Selec
locked cells is checked because I use the "Comments" as mouse-ove
pop-up instructions.
This works great except that I can't stop people from pasting into th
fields that are not locked. I would be fine if they pasted/value only
Does anyone know a way in VB to ensure that ALL pastes to a workshee
automatically and only use Paste/Value feature