Dim maForme As UserForm1 Set maForme = New UserForm1 maForme.Show ' la forme s'affiche mais rend la main de suite Do While maForme.Visible DoEvents ' Boucle d'attente du 'Hide' Loop Unload maForme Set maForme = Nothing
Private Sub UserForm_Activate() ThisWorkbook.Application.WindowState = xlMinimized Me.Show End Sub Private Sub CommandButton1_Click() ThisWorkbook.Application.WindowState = xlNormal Me.Hide End Sub
ThisWorkbook.Application.WindowState = xlMinimized