屏蔽屏幕更新提示，以及屏蔽链接提示

Application.ScreenUpdating = False

Application.DisplayAlerts = False
Application.AskToUpdateLinks = False

 

 

Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.AskToUpdateLinks = True