You want to trap Application events. This can be done using a class module.
The procedure is outlined on Chip Pearson's website:

http://cpearson.com/excel/AppEvent.htm

John Green

"doco" wrote in message
...
I have a procedure I wish to place into an add-in - simple enough done.
However, when this add-in is instaced I want this procedure to be called
from *any active* workbooks' Workbook_SheetSelectionChange(ByVal Sh As
Object, ByVal Target As Range) event. How is this done?

TIA
doco