Hi,

I am creating an add-in in Excel that will be used by various people within a department.

One of the functionalities I would like to add is a “drill-down” feature that upon double-clicking a number in a cell, Excel would query an Access database and return the detail that makes up the number.

My question is how to go about this? The Excel/Access interaction is not a problem, but how do I go about getting the double-clicking to work.
I’ve tried adding the “Workbook_SheetBeforeDoubleClick” sub in the add-in, but that only works if the add-in is active. I need this to work on whatever workbook is currently active (since the add-in is hidden anyway)
Also cross posted here:
http://www.mrexcel.com/forum/showthread.php?t=380424
Any suggestions would be greatly appreciated?
Thank!