Home how to implement a function of the addin of bex analyzer in vba
Reply: 0

how to implement a function of the addin of bex analyzer in vba

germancito332
1#
germancito332 Published in 2017-12-07 20:49:38Z

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.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.307652 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO