The short answer is you can't turn security warnings off. If you could then
anyone who wrote a virus would just turn them off. You can have every one
turn their security down to low but this would potenetially allow a virus to
get into the system. You can also look at digital signatures or trusted
sources. This starts to get a little dependant on your version of Excel so I
can't really comment further...

HTH

"Jeff Stroope" wrote:

I'm running a macro in Excel from within Access using Automation. I'm new to
Automation and I figured out how to open and close an Excel workbook using
Access VBA. I want to format the data in the Excel workbook to currency
after a transferspreadsheet action from Access. So I wrote a little fomat
macro in Excel to run at the open event. In Access, I open the workbook and
the immediately close it just to run the format macro. The problem is, I
can't figure out how to turn the macro warning off. I just want to run the
macro without the user having to click "Enable Macros". Anyone know how to
turn those warnings off?

Thanks,

Jeff.