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

http://google.com/groups?threadm=856...ing.google.com

--

Vasant



"Bill Oertell" wrote in message
...
Is there any way to preserve the destination formatting whenever a user
copies and pastes from another workbook?