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