No, unfortunately there is no built-in way to block format copy/pasting.
You have to disable copy and paste via code in all its manifestations
(menus, toolbars, keyboard shortcuts). Also cut and paste and using the
fill handle. Quite a pain.

--
Jim Rech
Excel MVP

"Vicar" wrote in message
...
| Is there a way of preventing formats being copied from other worksheets
into
| unprotected cells. Normal protection prevents formats being edited, which
is
| fine, but people can still copy data into the cells and thus change the
| format.