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).
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 ?