hindersaliva
asked on
Excel VBA - triggering a Sheet event on another workbook
I have some VBA code in Workbook1. The active workbook is Workbook2.
Workbook2 is an .xlsx, has no code, will not have any code.
Is it possible to 'wire up' a sheet event (eg. double click) on Workbook2 that will run some code in Workbook1?
(FYI the code I refer to will manipulate only cells on the active sheet in the active workbook Workbook2)
Thanks
Workbook2 is an .xlsx, has no code, will not have any code.
Is it possible to 'wire up' a sheet event (eg. double click) on Workbook2 that will run some code in Workbook1?
(FYI the code I refer to will manipulate only cells on the active sheet in the active workbook Workbook2)
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Pleased to help