Protect Sheet Format when Data is Pasted
 

Is there any way to protect my worksheets format?

The trouble is that when people copy and paste into my worksheet they always
paste the other sheets formats. I would like to be able to prevent this.

They need to be able to copy the data, but not the format.

Thanks,
Dan

Protect Sheet Format when Data is Pasted
 

Could you train them to CopyPaste SpecialValuesOKEsc?


Gord Dibben MS Excel MVP

On Thu, 20 Sep 2007 13:20:07 -0700, Draino
wrote:

Is there any way to protect my worksheets format?

The trouble is that when people copy and paste into my worksheet they always
paste the other sheets formats. I would like to be able to prevent this.

They need to be able to copy the data, but not the format.

Thanks,
Dan