View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Carlos[_6_] Carlos[_6_] is offline
external usenet poster
 
Posts: 14
Default create button in excel toolbar

try

Sub Macro1()

Dim oCell As Range
Set oCell = Range("e2")'selet your cell

l = oCell.Left
t = oCell.Top
h = oCell.Height
w = oCell.Width

ActiveSheet.Shapes.AddShape msoShapeOval, l, t, w, h
End Sub