Home how to implement a function of the addin of bex analyzer in vba
 Hi there. I'm trying to use a function of the Add In of the Bex Analyzer and I can't implement it using a macro. This is the sub I'm trying to use Public Sub SheetBeforeDoubleClick(ByVal iSheet As Worksheet, ByVal iTarget As Range, cCancel As Boolean) On Error Resume Next Call pAddin.ExcelInterface.SheetBeforeDoubleClick(iSheet, iTarget, cCancel) On Error GoTo 0 End Sub  I'm trying to use that function so when one sheet is opened, the macro is triggered. Sub Execute() Dim iTarget As Range Dim iSheet As Worksheet Dim CCancel As Boolean iTarget = Application.Range("B7") iSheet = Application.Worksheets("Sheet I want to open") CCancel = True Call SheetBeforeDoubleClick(iSheet, iTarget, CCancel) End Sub()  I want to use this code so when the sheet is activated, there's a double click in the cell B7. Thank you in advance.