OLEObjects.ADD causes excel vba project to stop / reset / go dead
Are you stepping through the code when it stops (using F8's?). If yes, then
don't step through it.
Maybe set a break point after that line of code???
Timothy Marks wrote:
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
--
Dave Peterson
|