Copy and Paste from ANOTHER WORKBOOK
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:
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
|