"IGNORE ERROR" macro

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: "IGNORE ERROR" macro

  1. #1
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    973
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default "IGNORE ERROR" macro

     
    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

  2. #2
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,381
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    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
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  3. #3
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    973
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Thank you, but when i run this, nothing happens, literally. I ran it with no cells selected and all cells selected.

    Thoughts?

  4. #4
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,381
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    it should just turn of the error checks, maybe change to false from true
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  5. #5
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    973
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Very Nice . . . . . Thanks.

  6. #6
    MrExcel MVP
    Join Date
    May 2009
    Posts
    14,679
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Quote Originally Posted by Jeffrey Green View Post
    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'
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

  7. #7
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    973
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    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

  8. #8
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,381
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Maybe JoMo way will do that, I assumed turn it off on one turned off the global option, I don't see errors
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  9. #9
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    973
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com