Protect Destination Formatting

[Bill Oertell]

Is there any way to preserve the destination formatting whenever a user
copies and pastes from another workbook?

 

[Vasant Nanavati]

A bit complicated and probably not foolproof, but see this thread for a
creative solution:

http://google.com/[email protected]

 

[Tom Ogilvy]

If you don't past formats, you won't change the destination format.

What do you really want to know?