<< Click to Display Table of Contents >> Navigation:  Problems / Errors > VBA missing

 

Synkronizer needs VBA macros to run some functions, but sometimes VBA (Visual Basic for Applications) is disabled or not installed.
 

 

Check if VBA is available
 
In Excel a simple check to see if VBA is available is to press [Alt][F11]. Normally this command opens a VB Editor window, but when it does not and you hear a beep then VBA is not available. If the Developer Tab is visible in the ribbon you'll notice the VB and Macro buttons in the Code group is disabled.

 

The most common way System administrators disable VBA is adding a setting in the registry.

for more information see:

 
https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/turn-off-visual-basic-for-application

 

 

VBA is disabled

 

You will find one or more entries called VBAOFF under one of the following keys, where XX is the version number of your Excel.

 

HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\Common

HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\XX.0\Common

HKEY_LOCAL_MACHINE\Software\Microsoft\Office\XX.0\Common

HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Office\XX.0\Common

HKEY_LOCAL_MACHINE\Software\WOW6432Node\Microsoft\Office\XX.0\Common

HKEY_LOCAL_MACHINE\Software\WOW6432Node\Policies\Microsoft\Office\XX.0\Common

 

The entry is a REG_DWORD value named VBAOFF. If the value is 1 VBA will be disabled.

To enable VBA the entry must be deleted or the value must be changed to 0.

 

 

VBA is not installed
 

In versions prior to Excel 365 or 2019 VBA was an optional component during setup. In the latest versions it is always installed.

 

You should find an entry called vbe7dllpath under one of the following keys:
 

HKEY_LOCAL_MACHINE\Software\Microsoft\VBA

HKEY_LOCAL_MACHINE\Software\WOW6432Node\Microsoft\VBA

HKEY_LOCAL_MACHINE\Software\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\VBA

 

If not then VBA is not properly installed. Proceed as follows: