ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error Trapping Options Change in Excel 1997 (https://www.excelbanter.com/excel-programming/296652-error-trapping-options-change-excel-1997-a.html)

Frank DeLuccia

Error Trapping Options Change in Excel 1997
 
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




All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com