Form causing Excel crash

[Brian.Crawford]

I have a small form that when I attempt to change even a simple "label" or any other part of it (ex. add a period '.' to the label text) results in the WB losing it's reference to the first WS in the book (both the WS and controls on it [ex. a combobox]). This loss of ref. occurs after I save the WB and then re-open it. If I haven't saved it yet it works normally after the change.
The loss of WS reference typically shows up as an error when trying to reference the WS as part of a Range statement ("Application-defined or object-defined error") during my initialization routine for the WB:
---Sheets("summary").Range("budgetyear") = WBInfo(1)
the WS is not protected at this point & WBInfo(1) has the correct data.
Interesting if I
-- ?range("budgetyear") [no dot]---in the immediate window it displays the correct value of budgetyear that pre-existed on the summary worksheet

I have deleted this form and recreated it from scratch but that has not helped. It consists of a combobox, label and a close button, but any change to it will trigger the error.

Upon dismissing the End/Debug dialog box and then attempting to close the WB (without saving) Excel immediately does a hard crash (faded 'white' screen of death) and then closes.

Any suggestions
Thanks all
Brian

 

[VoG]

I would suggest rebuilding your workbook http://www.mrexcel.com/forum/showthread.php?t=223851