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.

Trap SheetBeforeRightClick event from another workbook
 

you need application level events.
see http://www.cpearson.com/excel/AppEvent.htm


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


mp112849 wrote :

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.

Trap SheetBeforeRightClick event from another workbook
 

Thanks, keepITcool! This works when I open the data file with a
double-click from windows explorer. I haven't had a chance to try it
while opening the file once an instance of excel is running (from a
file/open), but will do that later.