I want to make sure that users cannot change the formatting of a cell if they
accidentally do a 'Paste SpecialValues' on the original cell. [Example:
Sheet2Cell A1 points to Sheet1Cell B19. User is instructed to 'Copy'
Sheet2CellA1 and 'Paste Special Values' to Sheet2Cell A2. If they
inadvertently 'Paste' to Sheet2CellA1, the source of Sheet2CellA1 is lost as
only values are displayed]

Is there a way in which I can write-protect Sheet2CellA1 while still being
able to Copy from it?

Thanks.

Mike