loop in creating oleobjects

[dmz]

I copied this code from vba express entitles Programatically add & delete OLE button and its code to & from a worksheet (& module)
Am trying to modify to create 3 buttons (AM Successful) nby using a do loop but am having difficulty in modify the code for the area with .codemoue area - excel blowup --Help

[lucas]

dmz.....what application are you working with...excel, word, access, etc.
someone will move this to the appropriate forum for you so the right people will see it and be able to help you....

also.....what code are you talking about?

[johnske]

Moved to Excel Help forum...

[Bob Phillips]

How odd, in crashes with me too. I will look into this.

[dmz]

Looking forward to problem resolution

[tstom]

That code utilizes the (Library VBIDE) Microsoft Visual Basic for Applications Extensibility. Unless you have granted access to the VB project, it will not work. Tools>Macro>Security>Trusted Publishers>Trust Access to Visual Basic Project must be checked as far as I know.

I would never, never do this in a workbook I was going to distribute.

There are other alternatives to sourcing events of dynamically added oleobejcts. Post some more details about your project please...