The VBA project status is in the registry in HKLM, it's a COM addin
registered under
HKLM\Software\Microsoft\Office\Outlook\Addins\Microsoft.VbaAddinForOutlook.1.
If LoadBehavior is set to 9 then VBA is loaded and enabled.
The various combinations of settings at
HKCU\Software\Microsoft\Office\12.0\Outlook\Security\ make up the various
macro settings. You can use a tool such as RegMon to find how those values
change as you change the various macro related settings. The "12.0" is for
Outlook 2007, adjust that for your own version, for example "11.0" for
Outlook 2003.
"Peter Kinsman" <peter@seguecomputing.co.uk> wrote in message
news:uYUS5vvKKHA.1248@TK2MSFTNGP04.phx.gbl...
> Some while ago, I installed FnSendMailSafe in readiness for a monthly
> emailing exercise. Last week the emailing database was altered to call
> FnSendMailSafe but in the meantime the operator had always taken the
> option to disable macros, so the call of FnSendMailSafe failed.
> The operator notes have been updated but does anyone know whether there is
> an accessible variable which shows whether macros are enabled please?
>
> Many thanks
>
> Peter Kinsman
>
>