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

Thread: VBA Disable Error Messages

  1. #1
    New Member
    Join Date
    Sep 2008
    Location
    Leeds, UK
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question VBA Disable Error Messages

    Hi,

    I'm pretty certain there is a way to disable any error messages using VB coding and I was wondering if someone could point me in the right direction.

    I believe it is done using the 'Application.' function but am not 100% sure

  2. #2
    Board Regular Mike Blackman's Avatar
    Join Date
    Jun 2007
    Location
    Basingstoke, UK
    Posts
    2,494
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Disable Error Messages

    Hi,

    Try;

    Code:
    On Error Resume Next
    Regards

    Mikey B

  3. #3
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    7 Thread(s)

    Default Re: VBA Disable Error Messages

    Or perhaps

    Code:
    Application.DisplayAlerts = False
    HTH, Peter
    Please test any code on a copy of your workbook.

  4. #4
    New Member
    Join Date
    Sep 2008
    Location
    Leeds, UK
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: VBA Disable Error Messages

    That's the one, thanks guys

  5. #5
    Board Member
    Join Date
    Dec 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Disable Error Messages

    any ideas how to stop this happening from vbscript ?

    the above entries don't stop fatal errors from showing

  6. #6
    Board Regular Mike Blackman's Avatar
    Join Date
    Jun 2007
    Location
    Basingstoke, UK
    Posts
    2,494
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Disable Error Messages

    Quote Originally Posted by slmandle View Post
    any ideas how to stop this happening from vbscript ?

    the above entries don't stop fatal errors from showing
    What are trying to do with vbs? I don't believe vbs has error handling to the same level vba has so the solution would be different, can you give a little bit of detail for your problem?
    Regards

    Mikey B

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
  •