Excel "Disable Macros; Enable Macros; More Info" prompt

[Guest_imported]

I am writing an Access application using VBA, after this line of code run, [Set xlobject = GetObject("C:\ExcelFiles\FileWithMacros.xls"], Excel "Disable Macros; Enable Macros; More Info" prompt come up (on top of the Access form). I'd like very much to enable this macro automatically without having to click on "Enable Macros". Or if somehow I can get the focus on that "Disable Macros; Enable Macros; More Info" prompt so that I can control it.

If you have some ideas on how to solve this problem, please let me know asap, I'd really appreciate it. -junior47-

 

[asjeff]

Suspect that you will have to manually set the Macro security settings to LOW in Excel. Am not sure that you can disable the macro dialogs programmatically because a virus would then be able to circumvent it, which would of course make them a pointless exercise. If anyone else knows of a way round this I would be interested to hear as I run across this all the time.

Hope this provides some help.

Asjeff