I've done this before and the best way to do it is to customize the file so
that all toolbars only allow pasting of values. You have to do this with
worksheet event macros. If you don't know how to do that, it's one of the
best programming techniques to learn.


"BethP" wrote in message
...
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