UserForm Hangs
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? |
UserForm Hangs
Impossible to tell w/out seeing the code...
Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Stratuser" wrote: 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? |
UserForm Hangs
Here it is. The problem is at the end of the subroutine.
Sub Auto_Open() Dim wkbk As Workbook FixStuff BuildingTable = False HoldingFileOpen = False Sheets("CoverPage").Activate Application.DisplayStatusBar = True 'Get paths to subdirectories GetSubdirectories 'Set default subdirectory to InputSubdirectory variable ChDir InputSubdirectory 'if an eVestment holdings list is already open, then import its data HoldingFileTest If HoldingFileOpen = True Then ImportEvestment Else: 'Show main menu form as usual MainMenuForm.Show End If End Sub "ryguy7272" wrote: Impossible to tell w/out seeing the code... Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Stratuser" wrote: 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? |
All times are GMT +1. The time now is 06:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com