Chris Adams wrote ...

I was hoping for a useful suggestion to help me find a Dr Watson
error.

I've a 1M calculator (built on 97 XL). It has:
? 7 pages
? 4 of those pages have about 30 comboboxes + 10 checkboxes (ActiveX)
? and the comboboxes & checkboxes on each page are entered into a
class collection upon that sheet being activated

I've:
? replaced all Activex comboboxes + checkboxes
? tried to narrow down the Dr Watson source by process of elimination
(this gets to the 4 pages, but then I realise the activex's on them
are linked to other pages via named ranges)
? deleted all surplus named ranges (and any with INDIRECT functions)
? resized all pages that were zoomed back to 100%
? set all objects in the code to Nothing at the end of each sub
(can/should I do this with the collection?)
? checked/removed any external workbook links
? cleared all rows and columns around the used ranges on each
worksheet
? looked at disabling Dr Watson, but sadly its not possible

As I see it, my only remaining step is to delete and rebuild each
worksheet. I'm putting that off at this stage because (i) its a
daunting task, and (ii) I'm running out of delivery time.

I've experienced something similar. In addition to what you described,
I was dynamically adding controls to my worksheet. The problem arose
when the workbook was saved with these controls in it. After the save,
the workbook was effectively corrupted. I could reopen the workbook
but re-saving it caused GPF. I found no way of recovering the
workbook. Of course, I had hourly backups in Visual Source Safe so
nothing was lost. I ended up changing my approach to the one you
described i.e. rather than adding controls at run-time, I had a fixed
number of controls that I made visible/invisible as required. This was
in Excel 2003, I'm not sure if other versions would be similarly
affected.

Did you create any of your controls dynamically? If you did, I'll bet
that your workbook went corrupt at this point. I hope I'm wrong though
and you manage to recover it. I would be interested in hearing any
more details you have.

If you do not have a backup from before this time then yes, I think
you do have to rebuild the workbook. I'd suggest start by removing the
controls and copying the sheets into another workbook.

Jamie.

--