Enable / Disable Auto Refresh

Hi all

I have a macro that is updating a file that has a Workbook_BeforeSave command attached to it that refreshes a query before the file saves. This query links to an external database - Access.

When my macro is running everything works fine but I keep getting the Enable / Disable Auto Refresh box come up. Any ideas on how to set this automatically on the file opening? I have tried using Application.DisplayAlerts = False to stop displaying it but this does not work.

Thanks

Matt