Clear all error indicators in an entire worksheet I understand the green triangl

Question

Clear all error indicators in an entire worksheet

I understand the green triangle error indicator in the upper left corner of a cell in Excel. I also understand that I can clear all the error checking so that those green triangles do not appear. My question is this: Can I clear all the error checking for just one workbook? I'd like the error checking in other workbooks, but not in the specific one I'm dealing with right now. So if I go to the error checking setting options, that seems to set it for all workbooks not just the one I'm currently working with.   

Explanation / Answer

With the workbook of interest active:

Alt-F11 to open the VBA editor

Alt-IM to insert a new code module

Ctrl-R to access the Project Explorer window

Double-click ThisWorkbook and paste the following code:

'=========>>

Option Explicit

'--------->>
Private Sub Workbook_Open()
Application.ErrorCheckingOptions.BackgroundChecking =False
End Sub

'--------->>
Private Sub Workbook_Activate()
Application.ErrorCheckingOptions.BackgroundChecking = False
End Sub

'--------->>
Private Sub Workbook_Deactivate()
Application.ErrorCheckingOptions.BackgroundChecking = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ErrorCheckingOptions.BackgroundChecking = True
End Sub
'<<=========

Alt-Q to close the VBA editor
Save the workbook as a macro enabled xlsm file; close and re-open the workbook.

===

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.