' These modules exist just to make other VBA code easier to write and more readable
' For example, you can just enter "NormalErrorProcessing" in your code
' instead of "On Error GoTo 0"
Sub NormalErrorProcessing()
On Error GoTo 0
End Sub
Sub NoErrorProcessing()
On Error Resume Next
End Sub
Sub EnableScreenUpdating()
Application.ScreenUpdating = True
End Sub
Sub DisableScreenUpdating()
Application.ScreenUpdating = False
End Sub
Sub HideGridlines()
ActiveWindow.DisplayGridlines = False
End Sub
Sub ShowGridlines()
ActiveWindow.DisplayGridlines = True
End Sub
Sub ToggleGridlines()
ActiveWindow.DisplayGridlines = Not ActiveWindow.DisplayGridlines
End Sub
Sub TurnOffCalc()
Application.Calculation = xlCalculationManual
End Sub
Sub TurnOnCalc()
Application.Calculation = xlCalculationAutomatic
End Sub
Sub ForceFullCalc()
ActiveWorkbook.ForceFullCalculation = True
End Sub
Sub EnableEvents()
Application.EnableEvents = True
End Sub
Sub DisableEvents()
Application.EnableEvents = False
End Sub
Sub UnProtectSheet()
ActiveSheet.Unprotect
End Sub
Sub TurnOnFormulaBar()
Application.DisplayFormulaBar = True
End Sub
Sub TurnOffFormulaBar()
Application.DisplayFormulaBar = False
End Sub
Sub ToggleFormulaDisplay()
ActiveWindow.DisplayFormulas = Not ActiveWindow.DisplayFormulas
End Sub
Sub TurnOffFilters()
ActiveSheet.AutoFilterMode = False
End Sub
Sub ResetScroll()
ActiveSheet.ScrollArea = ""
End Sub