+3  A: 

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\VBAWarnings=1 (REG_DWORD) is the setting you're looking for. It can also exist under HKLM as a machine-wide override. The location alos varies by office version; 2003=11.0; 2007=12.0.

Lastly, if you are in a managed IT environment, keep in mind that group policy may be changing it back for you.

JohnW  2009-03-09 13:13:10
+1 and I agree about the managed environment. We handle everything in regards to these type of messages thru policy control. It might be easier than having to go around to 80+ machines if you work in a large company :)
SomeMiscGuy  2009-03-09 13:20:10
Thanks, I have admin rights on all my test boxes, however these were pre-owned by regular users so some policy remnant may be in effect.
Salim Fadhley  2009-03-09 13:54:55
Are you saying that I set it to 1 in order to disable the messages? This does not seem to have an effect. I set it in HKCU and HKLM. When I load and excit Excel, the setting in in HKCU dissapears.
Salim Fadhley  2009-03-09 14:00:35
Yes, you set it to one to disable macro virus protection (enable all macros). Once you do that the messages will go away.
JohnW  2009-03-09 15:44:04

related questions

Verifying files for testing
How do you create your own moniker (URL Protocol) on Windows systems?
Windows Equivalent of 'nice'
Is this a good way to determine OS Architecture?
Dual vs. Quadcore on a Webserver
Is there a WMI Redistributable Package?
PHP Error - Uploading a file
Ruby On Rails with Windows Vista - Best Setup?
OpenVPN Config file to prevent timeout
How can I create Debian install packages in Windows for a Visual Studio project?
How do I configure and communicate with a serial port?
What's the best setup for Mono development on Windows?
Appropriate pagefile size for SQL Server
XML Editing/Viewing Software
Linux shell equivalent on IIS
What is a better file copy alternative than the Windows default?
Windows Help files - what are the options?
Heap corruption under Win32; how to locate?
Best way to access Exchange using PHP?
Get a preview jpeg of a pdf on windows?
WinForms ComboBox data binding gotcha
How do you schedule tasks in Windows?
Register Windows program with the mailto protocol programmatically
Embedding Windows Media Player for all Browsers
Best Subversion clients for Windows Vista (64bit)