Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trap SheetBeforeRightClick event from another workbook
I have an xla (workbook a) that loads when excel starts. The xla
contains forms, classes and modules that are used to validate and load data via a web service. The data is coming from another workbook (workbook b) that is either loaded into excel on demand through the normal file/open menu, or the user may have double-clicked the file icon in windows explorer or wherever. In either case, the workbook is open in the same instance of excel as the xla. My problem is that I must trap the double-click event of the workbook that holds the data. The "ThisWorkbook" module holds that event, and I cannot put any executable code in the event handler. I have tried using a technique that involves creating a class and declaring a WithEvents within that class similar to the following: Public WithEvents actvWkBk as Workbook that does not seem to work. So the double-click event of workbook b, must somehow be trapped in workbook a. Any help will be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trap show toolbar event | Links and Linking in Excel | |||
How to trap delete row event and hide column event? | Excel Programming | |||
How can i trap the rename event of an excel sheet? | Excel Programming | |||
Trap CTRL+C keypress event | Excel Programming | |||
how to trap a event coming from a dll | Excel Programming |