Disable Microsoft Access 2007 Security Warnings (Macro, Office 2007)

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

[sourcecode language=’bash’]
[HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0AccessSecurity]
“VBAWarnings”=dword:00000001
[/sourcecode]

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!