ActiveSheet.Buttons.Add(ActiveCell.Left, ActiveCell.Top, ActiveCell.Width, ActiveCell.Height)
[G1] = "Texte"
Columns(7).EntireColumn.AutoFit
With ActiveSheet.Buttons.Add([G1].Left, [G1].Top, [G1].Width, [G1].Height)
.Characters.Text = "Texte"
.AutoSize = True
Rows(1).RowHeight = .Height
End With
[G1].ClearContents