I have built a number of autonomous stand-alone applications withi
Excel. They do not link to any outside source or require anythin
external to run. The applications were built on NT/Excel97. Th
application spreadsheets are around 1.5Mb. I make considerable use o
combo boxes from the control toolbox both on custom forms and embedde
into spreadsheets.

The applications run without problem on Excel97/NT and have run withou
problem on Excel2000/Win2000. Since migrating to Excel2002/XP I hav
had untold problems of unrecoverable crashes [Excel has encountered
problem and needs to close….]. The crashes are not consistent.

In desperation I rebuilt the application completely on Excel2002/XP an
this brought a lot more stability but still there are irrecoverabl
crashes and I am at my wits end with this and knowing what I coul
possible do next.

The types of problems I have experienced:

- After some code has run, user goes to insert a entire row
Application crashes - Excel needs to close message …..

- After some code has run, user goes to save file in a differen
location : Application crashes.

- When a section of code has finished running, the left side of th
screen is hidden under a grey panel. All the functionality of th
spreadsheet exists beneath the panel is you know where you cursor is
but you can not reset your screen or recover.

- Applications run soundly the first time they are run, when closed an
run again they then crash. This is a very consistent pattern.

- I notice that if I compile the code immediately before saving m
saved workbook is of the magnitude of 1.95Mb. The applications wil
normally crash once it is opened. If I do not compile the code, an
just save the workbook, the file size if 1.5Mb and far less likely t
crash when it is opened.

- on opening get error message: Microsoft Visual Basic in the captio
bar with a warning triangle in the body of the message: Can't exi
design mode because control cmdSave cannot be created

- get a similar message telling me a particular contro
"Sheet03.cmbCountry" does not exist. On sheet03, there is the contro
cmbCountry.

- code would run past a set of lines:

Sheet04.Range("rgStartPoint").Offset(2,0).Select
Selection.EntireRow.delete

and fail to delete the row.

I have been trying to get these applications stable for some time no
and just go from one problem to another. I have no idea of where t
look next or what next to do and would appreciate any pointers or hel
you may be able to give me.

What is really frustrating is that the applications run without an
problem under NT/97 or on an Excel2000 on a Win2000 box. They jus
will not run under XP

--
mike_tyre
-----------------------------------------------------------------------
mike_tyrer's Profile: http://www.excelforum.com/member.php...fo&userid=1466
View this thread: http://www.excelforum.com/showthread.php?threadid=26285