Jim at Eagle wrote:
Rob is there a way to program in that setting so that strange
computers use spreadsheet?

Jim at Eagle wrote:
<....
In the VBE go to Tools | Options and on the General tab, ensure that
Error Trapping is set to Break on Unhandled Errors.

Rob

No. There may be hacks using sendkeys and/or possibly setting a registry
value, but there is no direct way of doing this using either the Excel or
VBE object models. The good news is that once the setting is done it will
persist across subsequent Excel sessions (unless/until the user resets it,
of course). However, if the user is stuck with Excel 97, the setting does
*not* persist and defaults to Break in Class Module every time Excel starts.
This is the main reason I have never used class modules in Excel, but have
always built all of my business logic into VB6 dlls.

Rob