F
Frank DeLuccia
Hello All,
I was wondering how do you get the error trapping option not to change?
Example: I go into Excel 97 and set the error trapping option to "Break on
Unhandeled Errors". I click OK and shut down Excel. However, when I
re-open a workbook, the option changed back to "Break in Class". Is there a
way to make my original selection stick? I've tried saving the workbook
after making my selection, thinking the setting was at the workbook level,
but it is not. I tried searching the registry to see if it's stored there,
but to no avail. I also tried searching the Excel object model to see if I
could set it through code, but couldn't find an exposed property either.
Any help would be greatly appreciated.
Thank!
-Frank
I was wondering how do you get the error trapping option not to change?
Example: I go into Excel 97 and set the error trapping option to "Break on
Unhandeled Errors". I click OK and shut down Excel. However, when I
re-open a workbook, the option changed back to "Break in Class". Is there a
way to make my original selection stick? I've tried saving the workbook
after making my selection, thinking the setting was at the workbook level,
but it is not. I tried searching the registry to see if it's stored there,
but to no avail. I also tried searching the Excel object model to see if I
could set it through code, but couldn't find an exposed property either.
Any help would be greatly appreciated.
Thank!
-Frank