View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Timothy Marks Timothy Marks is offline
external usenet poster
 
Posts: 9
Default OLEObjects.ADD causes excel vba project to stop / reset / go dead

This is pretty simple. I want to add a button to my
sheet--programatically. When I do it programatically the project stops.
Is there a workaround?

ThisWorkbook.Worksheets("Market
Report").OLEObjects.ADD(ClassType:="Forms.CommandB utton.1", Link:=False
_
, DisplayAsIcon:=False, Left:=2.25, Top:=256.5, Width:=18.75,
Height _
:=9).Select

Timothy Marks