Trap SheetBeforeRightClick event from another workbook

[mp112849]

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.

[keepITcool]

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.

[mp112849]

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.