Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003

    Unanswered: Set VBA Error Handling Options by Code

    Hi Everybody !

    I would like to be able to set the VBA error handling options (extras>options>general>error handling, i am not quite sure since i have the german version).

    Is it generally possible to set the extras>options ???

    Help would be veeeeery appreciated !!


  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Hi Boris

    I'm using UK so i am presuming the equivelent is Tools>>Options>>General (within the VBE). If so, I use:

    Application.SetOption "Error trapping", 1

    which sets Break on Unhandled errors. I don't programmatically change any other VB settings however they are usually possible to guess based on the text in the Option dialog box. I imagine you could enumerate them and then debug.print the various option names to identify any others that you can alter (can't say I've tried though).

    Hope this is along the lines of what you mean
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2003

    Excel doesnt support Application.SetOption

    Thanks for the help! This is exactly what I am looking for, but I forgot to mention, that I would like to do this in Excel, but it doesnt have this method ! (That's so Microsoft, Access Application object has it but Excel not ...)

    Does anybody know the equivalent for Application.SetOption in Excel ?

Posting Permissions

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