I've created a C# COM Excel Add-In, but am struggling to capture and recognise a double click event from Excel in C#?
e.g. in VBA I would add the below into the 'ThisWorkbook' module:
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Cancel = True
I could use this to trigger stuff in the C# add-in, but thought it would be more fluent to have the add-in respond to the double click event in Excel, rather then trying to add the above programmatically into Excel workbooks.
I'm trying to add Event Handlers, like below, but am struggling truth be told.
Excel.Application app = application as Excel.Application;
app.SheetBeforeDoubleClick += Excel.AppEvents_SheetBeforeDoubleClickEventHandler(beforeDoubleClick);
Any advice please?