EXCEL "workbook contains macros" warning message

[Alan]

I'm opening an excel workbook from an Access application.
I use Excel to make some calculation and send the info
back to Access.
Since I have to call excel multiple times, I'd like to
stop the warning message from popping up every time I open
the workbook. I can't set security from "medium"
to "low". Any suggestions?

 

[Chris]

Hi Alan,
See my post in the forum at:
microsoft.public.word.mailmerge.fields

dated 10 sept 2003 'High Security Setting' for more info.

'Run the Auto_Open macro
.ActiveWorkbook.RunAutoMacros 1 'xlAutoOpen

can be used to run the Auto_Open macro without the warning
even on high security. The answer I got was that the
macros could be digitally signed so that they don't cause
the warning. Haven't tried that one yet.

HTH
Chris