Private Sub Workbook_Open()
With Application.CommandBars("Cell").Controls.Add(Type:=msoControlButton, Before:=1)
.OnAction = "Ecrit"
.FaceId = 31
.Caption = "Ecriture"
End With
Application.CommandBars("Cell").Controls(2).BeginGroup = True
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
With Application.CommandBars("Cell").Controls.Add(Type:=msoControlButton, Before:=1)
.OnAction = "Ecrit"
.FaceId = 31
.Caption = "Ecriture"
End With
Application.CommandBars("Cell").Controls(2).BeginGroup = True
End Sub
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Target.FormulaR1C1 = Val_Ecriture
End Sub
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Application.CommandBars("Cell").Reset
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Cell").Reset
End Sub