Prevent Copying of Cells into Workbook

Topic

New Reply

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

Reply | Quote