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
I'm trying to use that function so when one sheet is opened, the macro is triggered.
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)
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.