formatting help

[Marc]

I have a spreadsheet full of validations and different
formatting. I want to protect it all but at the same
time, let the user change the values in all the cells.
Everything seems to work except with it comes down to
copy and pasting. If I copy from a certain cell with a
certain format and then paste it in a different cell with
a DIFFERENT format, it somehow overides the format.

Cell 1 has numbers
Cell 2 accepts only letters

Copy cell 1 into cell 2 and it works yet if you type it
manually without copy pasting there is a pop up with an
error.

Any ideas on how I can protect the formatting so even
the "copy & paste" won't get rid of it?!

Thanks,

Marc

 

[Guest]

Do you know by any chance if it would be possible using
vba? I'm trying to avoid using the paste special if
possible.

Thanks for responding so quickly!

-----Original Message-----
Not exactly, but you can paste without affecting the

formats. Instead of selecting "Paste", try "Paste
special" and then select Formulas.

 

[Marc]

Thanks for your help!

-----Original Message-----
Sorry Marc, not my strong point.


.