One idea...

You could run a VBScript before opening the Excel file to set the macro
security to medium or even low. Here is a script that will change the macro
security level to low for Excel XP. The path may change a bit for different
versions of Excel.


Option Explicit
Dim objShell, RegLocate
Set objShell = WScript.CreateObject("WScript.Shell")
On Error Resume Next
RegLocate =
"HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\ Excel\Security\Level"
objShell.RegWrite RegLocate,"1","REG_DWORD"
WScript.Quit




"Mariam Mata" wrote in message
...

I need to enable macros on open event...

Sugggestions,
Thnaks a lot !

*** Sent via Developersdex http://www.developersdex.com ***