Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub workbook_newsheet(ByVal Sh As Object) Dim Obj As Object Dim Code As String Sh.Select On Error Resume Next '*********** Mise en forme ************ Rows(1).RowHeight = 42 Rows(2).RowHeight = 35 '********** Nom de la feuille ********* Sh.Name = DatePart("d", Date) & "." & DatePart("m", Date) & "." & DatePart("yyyy", Date) '*********** crée le bouton *********** Set Obj = ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", _ Link:=False, DisplayAsIcon:=False, Left:=5, Top:=5, Width:=150, Height:=35) Obj.Name = "BoutonTest" '********** texte du bouton *********** ActiveSheet.OLEObjects(1).Object.Caption = "Calcul Marge" '********* Le texte de la macro ******* Code = "Sub BoutonTest_Click()" & vbCrLf Code = Code & "Call Module1.MAJMacro" & vbCrLf Code = Code & "End Sub" '* Ajoute la macro en fin de module feuille * With ActiveWorkbook.VBProject.VBComponents(ActiveSheet.Name).CodeModule .insertlines .CountOfLines + 1, Code End With End Sub
With ActiveWorkbook.VBProject.VBComponents(ActiveSheet.Name).CodeModule .insertlines .CountOfLines + 1, Code End With