Hi,

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.

Based on what I've read about the good Dr in archives, I'm not sure
there is an answer, but if there are any useful suggestions, I'd very
much appreciate them.

Many thanks in advance for your time,
Chris Adams