Force values-only when pasting text to keep formatting
 

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

Force values-only when pasting text to keep formatting
 

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

Force values-only when pasting text to keep formatting
 

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

"Jeff Stevens" wrote:

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