Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
software_development:performance_of_vba [2017/03/03 13:34] – removed prgram | software_development:performance_of_vba [2025/07/07 14:12] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code vb> | ||
+ | Application.ScreenUpdating = False | ||
+ | Application.DisplayStatusBar = False | ||
+ | Application.Calculation = xlCalculationManual | ||
+ | Application.EnableEvents = False | ||
+ | Application.ScreenUpdating = True | ||
+ | Application.DisplayStatusBar = True | ||
+ | Application.Calculation = xlCalculationAutomatic | ||
+ | Application.EnableEvents = True | ||
+ | |||
+ | |||
+ | 열려 있는 모든 통합 문서 | ||
+ | 특정 워크시트 | ||
+ | 특정 범위 | ||
+ | Worksheets("" | ||
+ | |||
+ | range(" | ||
+ | Range(" | ||
+ | </ |