1 2 3 4 5 6 7 8 9
| #If Win64 Then
Private Declare PtrSafe Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As Long
#Else
Private Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As Long
#End If
Private Sub Workbook_Open()
'-1 = toujours au premier plan, -2 = normal
SetWindowPos Application.hwnd, -1, 0, 0, 0, 0, &H2 Or &H1
End Sub |
Partager