MenuHandlerGlobals Class

global ribbon variable and procedures for MenuHandler

Inheritance Hierarchy

Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

public sealed class MenuHandlerGlobals

The MenuHandlerGlobals type exposes the following members.

Methods

NameSummary
public methodcheckHiddenExcelInstance()
check for multiple excel instances
public methodcheckMultipleDBRangeNames(Range)
check if multiple (hidden, containing DBtarget or DBsource) DB Function names exist in theRange
public methodjumpButton()
jumps between DB Function and target area
public methodrefreshData()
refresh DB Functions (and - if called from outside any db function area - all other external data ranges)
public methodresetCachesForWorkbook(String)
resets the caches for given workbook

Fields

NameDescription
public fieldtheAdHocSQLDlg
This needs to be public accessible for click handler to pass results into SQLText control
public fieldtheRibbon
reference object for the ribbon