On Jun 22, 4:25*pm, Per Jessen wrote:
On 22 Jun., 08:59, Len wrote:

Hi,

How to set an excel VBA code to disable or ignore the message box
prompts as " This workbook contains links to other data sources.If you
update the link...... If you don't update the link.... " in the mid of
executing a macro.

Please help, thanks

Regards
Len

Hi Len

Application.DisplayAlerts = False

Remember to set it = True when you are done.

Regards,
Per

Hi Per,

Thanks for your reply and based on your suggestion, I try to set a
macro as follows and run it : -


Application.DisplayAlerts = False
Workbooks.Open _
Filename:="F:\Accts\Jap\May'08\OA.May'08.4th.xls",
Application.DisplayAlerts = True

However, it still prompts the same message box in the mid of running
the macro.

Did I miss out anything in the above code ?

Regards
Len