VBA中防止屏幕更新的方法

Application.DisplayAlerts = False
Application.ScreenUpdating = False

main

Application.DisplayAlerts = True
Application.ScreenUpdating = True

Comments are closed.