Skip to content

References

The References dialog controls which of VBA Padlock’s built-in library modules are compiled into your protected DLL. Tick ExcelConstants, for instance, and the compiler recognizes xlUp, xlCellTypeVisible, and every other xl* symbol your code uses, no magic numbers required. Open it with the References button in the Protect tab’s Project group.

The References dialog: constant modules tree on the left, module description on the right


The left pane lists the available modules as a checkbox tree; select one to read its documentation in the preview pane.

ModuleProvides
ExcelConstantsThe xl* constants (Excel).
WordConstantsThe wd* constants (Word).
PowerPointConstantsThe pp* constants (PowerPoint).
AccessConstantsThe ac* constants (Access).
OfficeConstantsThe shared mso* constants.
MSFormsConstantsThe fm* constants (Microsoft Forms 2.0).
FinancialFinancial functions (PMT, PV, NPV, IRR, …).
ErrorHandlerError-handling helpers.

Checked modules are compiled into the DLL with your code and saved with the project; unchecked ones cost nothing. If a constant doesn’t resolve at compile time, tick the missing module and run a Syntax Check.


Compile & Syntax Check

Validate your project after changing references. View Reference →