My way of Exiting tool in case or error, also another sub that basically does nothing.
Two (or 4?) of my standard small subs that can standardize the work like...
Exiting sub safely without leaving anything behind, like Calculation or ScreenUpdating.
And DoNothing can be helpful by linking objects in Excel spreadsheet to it, instead of allowing users to selecting them and modifying them.
Sub DoNothing()
End Sub
Sub ExitTool()
ExitVBATool
End Sub
Sub ByeBye()
ExitVBATool
End Sub
Sub ExitVBATool()
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.EnableEvents = True
End
End Sub
End Sub
Sub ExitTool()
ExitVBATool
End Sub
Sub ByeBye()
ExitVBATool
End Sub
Sub ExitVBATool()
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.EnableEvents = True
End
End Sub
Views 829
Downloads 307
CodeID
DB ID
ANmarAmdeen
602
Revisions
v1.0
Saturday
October
31
2020