User form suddenly restarting excel upon closing

[JeffGrant]

Hi All,

I have a user form that has been around for over two years. It is my main userform that controls the workbook.
For whatever reason, in the last two weeks, Excel opens and immediately creates a recovery file.
I have woked out that if I manually close this main userform, Excel will close normally. However, if I leave the user form open, which I have been doing for several years, Excel will automatically restart.
I have tried putting an unload userform statement in a Private Sub Workbook_Close() routine, but that does not make any difference.

Could the user form have become corupt and I need to rebuild ?

All ideas and comments are most appreciated.

 

[JeffGrant]

Problem Solved.

I came accros this set of tools

Home

Ribbon Commander. A framework for rapid Office UI development

www.ribboncommander.com

I ran the Clean VBA Project function and the problem has been solved.