I have recently converted from Excel 2003 to Excel 2007. Two old programs
have macros that start automatically with Auto-Open, and both have the same
problem in Excel 2007, which never happened in Excel 2003: the userform
called up by the Auto_Open subroutine hangs. Then the Cancel button on the
userform won't do anything, and I have to delete the form with the form's
delete button. However, this does not happen when I restart the macro with a
control that is on the worksheet. It has something to do with Auto_Open.
Any ideas?