View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default 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.