Protect Sheet Format when Data is Pasted

D

Draino

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
 
G

Gord Dibben

Could you train them to Copy>Paste Special>Values>OK>Esc?


Gord Dibben MS Excel MVP
 
Top