ChrisOswald
Active Member
- Joined
- Jan 19, 2010
- Messages
- 454
Hi,
I'm having some problems with some code breaking on other peoples computers. The code breaks are all in this type of format:
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:
I'm having some problems with some code breaking on other peoples computers. The code breaks are all in this type of format:
Code:
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