Hi all,

I turn on protection on Worksheet with only Select unlocked Cells enabled.

When I drag a cell and drop it onto somewhere else by positioning cursor
right on the border it pastes the orignial cell's format (e.g., border and
background colour) to the new destination. Moreover, the original cell was
left with white background...

How can I prevent this from happening? I don't think we can with Protection
option... Or, do it via macro?

Thanks in advance.
---
Tetsuya Singapore