Changing the VBE's settings programmatically

[ChrisOswald]

Hi,

I'm having some problems with some code breaking on other peoples computers. The code breaks are all in this type of format:

on error resume next
'do something that deletes something that might not exist
on error goto 0

I've figured out that it's caused by the VBE having Tools -> Options -> General -> 'Break on all errors' selected.

What I want to know is if there's a way to change the setting programmatically, or if I'm going to have to run around to everyone's computer and change it. Or if there's a better way to handle this, because as cpearson.com says:

CAUTION: Many VBA-based computer viruses propagate themselves by creating and/or modifying VBA code. Therefore, many virus scanners may automatically and without warning or confirmation delete modules that reference the VBProject object, causing a permanent and irretrievable loss of code. Consult the documentation for your anti-virus software for details

 

[shg]

Curious; that doesn't work in Excel, and last year, Chip Pearson said this:

You can't change the error handling programmatically. (Well, I suppose it is stored somewhere in the registry, so I guess it is technically possible.) But generally, this is a manual setting.

http://www.thecodecage.com/forumz/e...y-set-error-trapping-visual-basic-editor.html

The Office cross-pollination behavior is annoying.

 

[ChrisOswald]

Well, it looks like Chip Pearson's still right...

Sub DontDoThis()
    Dim AppAcc As Object
 
    Set AppAcc = CreateObject("Access.Application")
    AppAcc.setoption "Error Trapping", 0
    AppAcc.Quit
    Set AppAcc = Nothing
End Sub

doesn't change the current VBE setting, but it does change future VBE settings. Unless you're putting this in an Access module, I guess. Although, I guess this exact code in Access wouldn't change the calling instance.

That's twice today I found an excuse to create a second instance of a MSOffice program. I think I might be coming down with something.