Private Declare Function FindWindow Lib "User32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function SetWindowLong Lib "User32" Alias "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Declare Function GetWindowLong Lib "User32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long
Private Const GWL_STYLE As Long = (-16)  'The offset of a window's style
Private hWnd, IStyle
Public x0, y0 As Integer
Public numRow As Integer
Public Sub MinMaxSupp(F As Object)
    hWnd = FindWindow(vbNullString, F.Caption)
    IStyle = GetWindowLong(hWnd, GWL_STYLE) Or &H70000
    SetWindowLong hWnd, GWL_STYLE, IStyle
End Sub


Sub Macro13()
'
' Macro13 Macro
'

'
    Rows("6:6").Select
    ActiveWindow.FreezePanes = True
    Range("A1").Select
End Sub
Sub feuille_loto()
    Sheets("loto").Select
End Sub

Sub copieCode()

'Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
'textid = ActiveControl.Name
    'trouver (1)
'End Sub

ActiveSheet.Range("a10:z1000").Select
Selection.ClearContents
ActiveSheet.Range("a10").Select

y = 1
n = 11
Do While y < 51
'    m1 = "Private Sub TextBox" & y & "_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)"
'    m2 = "if choix1.enabled = true then trouver (" & y & ")"
'    m3 = "End Sub"
'
'    ActiveSheet.Cells(n, 1) = m1
'    n = n + 1
'    ActiveSheet.Cells(n, 1) = m2
'    n = n + 1
'    ActiveSheet.Cells(n, 1) = m3
'    n = n + 1

m1 = "TextBox" & y & "=" & y
ActiveSheet.Cells(n, 1) = m1
n = n + 1


y = y + 1
Loop




End Sub