"IGNORE ERROR" macro

Jeffrey Green

Well-known Member
Joined
Oct 24, 2007
Messages
1,021
We do a lot of work with clients who like to have data start with 0, and other stuff.

Today i have a worksheet with 5 columns of in-cell green triangle error alerts. i like those, but not with certain clients.

My kingdom for a macro that will "IGNORE ERROR" on the entire sheet at once.

Possible? thanks
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
like this ?

Code:
Sub Macro1()
    With Application.ErrorCheckingOptions
        .EvaluateToError = True
        .TextDate = True
        .NumberAsText = True
        .InconsistentFormula = True
        .OmittedCells = True
        .UnlockedFormulaCells = True
        .EmptyCellReferences = True
        .ListDataValidation = True
        .InconsistentTableFormula = True
    End With
End Sub
 
Upvote 0
Thank you, but when i run this, nothing happens, literally. I ran it with no cells selected and all cells selected.

Thoughts?
 
Upvote 0
it should just turn of the error checks, maybe change to false from true
 
Upvote 0
We do a lot of work with clients who like to have data start with 0, and other stuff.

Today i have a worksheet with 5 columns of in-cell green triangle error alerts. i like those, but not with certain clients.

My kingdom for a macro that will "IGNORE ERROR" on the entire sheet at once.

Possible? thanks
Turn off error checking File>Options>Formulas> Error Checking --> uncheck 'Enable background error checking'
 
Upvote 0
Sorry, i spoke to soon . . . . that macro turns off my Error checking options . . . universally. I would like the macro to just "Ignore Errors" as if i was selecting that i the little pull down on the first cell . . . . just for that data range
 
Upvote 0
Maybe JoMo way will do that, I assumed turn it off on one turned off the global option, I don't see errors
 
Upvote 0
I am doing a work around using JoMo's way. I duplicate the Macro, and changed FALSE to TRUE. I named one macro ERRORSOFF and the other ERRORSON. I run OFF to see what i want to see, and run ON for the next workbook where i want to see errors. Then i put both on my quick access toolbar.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top