formatting help

  • Thread starter Thread starter Marc
  • Start date Start date
M

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
 
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
Click to expand...
formats. Instead of selecting "Paste", try "Paste
special" and then select Formulas.
 
Back
Top