Copy and Paste from ANOTHER WORKBOOK

  • Thread starter F. Lawrence Kulchar
  • Start date
F

F. Lawrence Kulchar

How can I temporarily disable the paste function from 1 workbook to another?
In other words, when I enter data into the source workbook, I do NOT want it
pasted into the destination workbook until I "ENABLE" that function.

Please advise.

Thank you,

FLKulchar
 
S

Stefi

Perhaps you could protect the destination sheet of the destination workbook
and unprotect it when you want to enable pasting:

Workbooks("destination workbook").Sheets("destination sheet").Protect
DrawingObjects:=True, Contents:=True, Scenarios:=True
....

Workbooks("destination workbook").Sheets("destination sheet").Unprotect

Regards,
Stefi

„F. Lawrence Kulchar†ezt írta:
 
Top