Preventing formatting changes in a protected worksheet

S

Singh

Using the Tools --> Protection --> Allow Users to Edit Ranges function, I can
prevent users from manually changing the formatting of cells I allow them to
edit.

However, if the user copy/pastes a cell into one of these editable cells,
the formatting changes accordingly. Is there any way to prevent this (i.e.
allow "paste values" only)?
 
Top