Force values-only when pasting text to keep formatting

[Guest]

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

 

[Jeff Stevens]

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.

 

[Guest]

Thanks for the reply! I think in the case of this form, that may be more
work then will pay off. But you're right, I definitely need to learn some
macro programming. (Someday, in my spare time!)

-beh=th