tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,926
- Office Version
- 365
- 2019
- Platform
- Windows
I have two workbooks within the same instance of Excel, wb1 and wb2.
wb1 has this code in ThisWorkbook:
If I go to wb2 and copy the contents of a cell and try to paste it into wb1, nothing gets pasted.
I suspect it has to do with the event above, (which is there so that other Excel files opened via Windows Explorer open in a separate session of Excel).
So is it possible to retain the event AND enable copying from wb2 to wb1?
Thanks
wb1 has this code in ThisWorkbook:
Code:
Private Sub Workbook_Activate()
Application.IgnoreRemoteRequests = True
End Sub
If I go to wb2 and copy the contents of a cell and try to paste it into wb1, nothing gets pasted.
I suspect it has to do with the event above, (which is there so that other Excel files opened via Windows Explorer open in a separate session of Excel).
So is it possible to retain the event AND enable copying from wb2 to wb1?
Thanks
Last edited: