REGEDIT:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security
(Replace 12 with your current version)

New DWORD:

VBAWarnings
1

Source: Bytes