The following routine will prevent cells from another workbook being copied into this workbook:

Code:
Private Sub Workbook_WindowActivate(ByVal Wn As Window)
Application.DisplayFormulaBar = True
End Sub
..go figure!
I've been using this since Jan 2001.
Copy the routine above into the ThisWorkbook object (i.e not into a standard vba module)

zeddy