Another question for all you Excel geniuses--

We have created a form where staff will be pasting in a body of text copied
from another report. We formatted this form, including bordering the text
area where the text needs to be pasted, and locked down all of the space that
needs to be static. Applied protection and saved. Unfortunately, whenver we
paste the text in to this space, it overrides the cell formatting and wipes
out the borders. We can get around this by pasting Values only. Is there
any way to force values only when pasting in a protected worksheet?

Thanks!!
-beth