Disabling Security Warning Box
The easiest way to do this is to add a registry key to turn VBA Warnings Off:

1. Open Notepad

2. Paste in:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
“VBAWarnings”=dword:00000001

3. Save as filename.reg

4. Run filename.reg, and say YES when it asks if you want to add the registry key.

As you may have guessed, you can add the same DWORD to the other directories like WORD, EXCEL etc.

Version 12 is for Office 2007, but this also works with 11.0, 10.0 versions of OFFICE.

Enjoy Hacking!