Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error renaming Worksheets when addin is loaded
Hello:
I wrote an addin that works fine in Excel 2003. But when loaded in Excel 2007 it causes a crash if I try to rename a worksheet in any file I happen to have open. If I unload the addin the problem goes away. The addin has several thousand of lines of code and I don't have a clue to where the problem is. Does anyone have a suggestion as to where I might look for the problem? Or what kinds of routines are likely to cause this type of problem? Thanks for any isight. Pieter Vandenberg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error renaming Worksheets when addin is loaded
I don't have XL 2007 (thank you) but you should be able, in the VBE, to go to Tools | Options | General (tab) and change the Error Trapping selection to "Break on all Errors". Then try renaming a sheet, the code should stop when the error occurs and you will be able to see the troublesome section. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "vandenberg p" wrote in message Hello: I wrote an addin that works fine in Excel 2003. But when loaded in Excel 2007 it causes a crash if I try to rename a worksheet in any file I happen to have open. If I unload the addin the problem goes away. The addin has several thousand of lines of code and I don't have a clue to where the problem is. Does anyone have a suggestion as to where I might look for the problem? Or what kinds of routines are likely to cause this type of problem? Thanks for any isight. Pieter Vandenberg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error renaming Worksheets when addin is loaded
Jim:
Thank you, that's a good suggestion and I will give it a try, I don't have a good feeling about 2007 yet, maybe it will "grow on me." I still use 2003 for most everything. Pieter Vandenberg Jim Cone wrote: : : I don't have XL 2007 (thank you) but you should be able, in the VBE, : to go to Tools | Options | General (tab) and change the Error Trapping : selection to "Break on all Errors". : Then try renaming a sheet, the code should stop when the error occurs : and you will be able to see the troublesome section. : -- : Jim Cone : San Francisco, USA : http://www.realezsites.com/bus/primitivesoftware : (Excel Add-ins / Excel Programming) : "vandenberg p" : : wrote in message : Hello: : I wrote an addin that works fine in Excel 2003. But when loaded in Excel 2007 it : causes a crash if I try to rename a worksheet in any file I happen to have open. : If I unload the addin the problem goes away. : The addin has several thousand of lines of code and I don't have a clue to where the : problem is. Does anyone have a suggestion as to where I might look for the problem? : Or what kinds of routines are likely to cause this type of problem? : Thanks for any isight. : Pieter Vandenberg |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error renaming Worksheets when addin is loaded
On Oct 30, 3:51 am, "Jim Cone" wrote:
I don't have XL 2007 (thank you) but you should be able, in the VBE, to go to Tools | Options | General (tab) and change the Error Trapping selection to "Break on all Errors". Then try renaming a sheet, the code should stop when the error occurs and you will be able to see the troublesome section. -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "vandenbergp" wrote in message Hello: I wrote an addin that works fine in Excel 2003. But when loaded in Excel 2007 it causes a crash if I try to rename a worksheet in any file I happen to have open. If I unload the addin the problem goes away. The addin has several thousand of lines of code and I don't have a clue to where the problem is. Does anyone have a suggestion as to where I might look for the problem? Or what kinds of routines are likely to cause this type of problem? Thanks for any isight. PieterVandenberg Hello: Finally got back to the project and the problem is that Excel crashes so you do not have a chance to choose to debug. And it does appear to be a problem within Excel not in my routine, although it does appear that my routine contributes to the problem, but Excel should really not be crashed by something my add-in does. Anyway still looking for any feedback on how I can trace the problem. Thanks. Pieter |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error renaming Worksheets when addin is loaded
Pieter Vandenberg wrote:
: On Oct 30, 3:51 am, "Jim Cone" wrote: : I don't have XL 2007 (thank you) but you should be able, in the VBE, : to go to Tools | Options | General (tab) and change the Error Trapping : selection to "Break on all Errors". : Then try renaming a sheet, the code should stop when the error occurs : and you will be able to see the troublesome section. : -- : Jim Cone : San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware : (Excel Add-ins / Excel Programming) : : "vandenbergp" : : wrote in message : Hello: : I wrote an addin that works fine in Excel 2003. But when loaded in Excel 2007 it : causes a crash if I try to rename a worksheet in any file I happen to have open. : If I unload the addin the problem goes away. : : The addin has several thousand of lines of code and I don't have a clue to where the : problem is. Does anyone have a suggestion as to where I might look for the problem? : Or what kinds of routines are likely to cause this type of problem? : : Thanks for any isight. : PieterVandenberg : Hello: : Finally got back to the project and the problem is that Excel crashes : so you do not have a chance to choose to debug. And it does appear to : be a problem within Excel not in my routine, although it does appear : that my routine contributes to the problem, but Excel should really : not be crashed by something my add-in does. : Anyway still looking for any feedback on how I can trace the problem. : Thanks. : Pieter I wanted to follow up with the comment that if I change the sheet name programmatically with a routine such as: Sub renamesheet() Dim Rsheet As String Rsheet = InputBox("New Name of Sheet", , "Result") ActiveSheet.Name = Rsheet End Sub Excel 2007 will not crash. Pieter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stuck addin loaded | Excel Programming | |||
Display sheet from loaded Addin | Excel Programming | |||
Addin opened but not loaded | Excel Programming | |||
XLL addin not loaded! | Excel Programming | |||
Addin loaded but Macro not shown | Excel Programming |