Quantitative Analysis
Parallel Processing
Numerical Analysis
C++ Multithreading
Python for Excel
Python Utilities

I. Motivation and design (PFE).
II. Installation of the Python for Excel.
III. Tutorial introduction into the Python for Excel.
IV. PFE Programmer's reference.
1. Direct access to Excel API.
2. Lower level access to Excel API.
3. Event trapping (PFE).
A. OnNewWorkbook property (ExcelListener).
B. OnSheetActivate property (ExcelListener).
C. OnSheetBeforeDoubleClick property (ExcelListener).
D. OnSheetBeforeRightClick property (ExcelListener).
E. OnSheetCalculate property (ExcelListener).
F. OnSheetChange property (ExcelListener).
G. OnSheetDeactivate property (ExcelListener).
H. OnSheetFollowHyperlink property (ExcelListener).
I. OnSheetSelectionChange property (ExcelListener).
J. OnWindowActivate property (ExcelListener).
K. OnWindowDeactivate property (ExcelListener).
L. OnWindowResize property (ExcelListener).
M. OnWorkbookActivate property (ExcelListener).
N. OnWorkbookBeforeClose property (ExcelListener).
O. OnWorkbookBeforePrint property (ExcelListener).
P. OnWorkbookBeforeSave property (ExcelListener).
Q. OnWorkbookDeactivate property (ExcelListener).
R. OnWorkbookNewSheet property (ExcelListener).
S. OnWorkbookOpen property (ExcelListener).
4. Configuration files (PFE).
Index. Contents.

OnSheetBeforeRightClick property (ExcelListener).

f the user right clicks at any Excel cell then the context menu pops up. The Excel fires the "before right click" event before it displays the menu. The property OnSheetBeforeRightClick provides facilities for trapping such event.


The signature() method reveals that the event handler is expected to accept two arguments and return a boolean value. If the returned value is true then the event would be canceled and the menu would not be displayed.

We insert the event handler as shown below.


Consequently, the context menu no longer pops up and the ControlShell receives new output every time the user right clicks on a cell.


Index. Contents.

Copyright 2007