Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: get rid off Excel Error MsgBox???

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anybody know how I can get rid off a Excel error message? I just want it to simply click ok, and then continue. Is there a line of code that can do this, do I have to trap this error?
    Any recommendation is appreciated.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Application.DisplayAlerts = False
    "your code"
    Application.DisplayAlerts = True
    End Sub

    James

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    James, thanks. But it gives an error when I saved the document(trying to share workbooks), so it is not related to my code, it is related to excel. I want to get rid of that message by automatically making it to click on OK. Any idea? Thanks again.

Some videos you may like

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
  •