I am trying to disable the automatic refresh prompt when loading a workbook.

I have tried the Application.DisplayAlerts = False but no joy.

Anyone help?

Thank you.

Richard