ThrottleWorks
Excel Ninja
Hi,
This might appear as silly post. However I need guidance on below.
I use below mentioned four lines at start of every macro I write (and kill at the end).
ScreenUpdating I know will run macro faster.
DisplayAlerts I know, will not throw un-necessary prompts.
I wanted to know if I should anything more as good practise to below lines.
Please help if you get time.
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.CutCopyMode = False
Application.StatusBar = "Macro running"
This might appear as silly post. However I need guidance on below.
I use below mentioned four lines at start of every macro I write (and kill at the end).
ScreenUpdating I know will run macro faster.
DisplayAlerts I know, will not throw un-necessary prompts.
I wanted to know if I should anything more as good practise to below lines.
Please help if you get time.
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.CutCopyMode = False
Application.StatusBar = "Macro running"