open another workbook - close - see again original form

Hi, Mario,

I didnīt expect that the other workbook had a form as well and should be closed via that form. In that case the event which is triggered if a workbook is closed "as usual/normal" doesnīt get fired. A workaround for that is to call the macro to show the first form again before the workbook is closed:

Private Sub cmbquit_Click()
Unload aanvang
ActiveWorkbook.Save
If Application.Workbooks.Count = 1 Then 'quit Excel if only one workbook open
    Application.Quit
Else
    Application.Run "test1.xlsm!start"
    ActiveWorkbook.Close
End If
End Sub

Ciao,
Holger