Dear All,

What code do I use to reference and then delete a commandbutton that is
embedded on a worksheet in workbook(B).
The code has to go in a module in workbook(A).

Any help greatly appreciated
Jason

Hi jase

If the workbook is open you can use this for a control toolbox button

Workbooks("OtherWorkbook.xls").Sheets("Sheet1").OL EObjects("TheButton").Delete


--
Regards Ron de Bruin
http://www.rondebruin.nl



"jase" wrote in message oups.com...
Dear All,

What code do I use to reference and then delete a commandbutton that is
embedded on a worksheet in workbook(B).
The code has to go in a module in workbook(A).

Any help greatly appreciated
Jason

cheers Ron

so the OLEObjects collaction comprises all things embedded in
worksheets?

Nope. For instance, you can add controls from the Forms toolbar or shapes from
the Drawing toolbar. These aren't OLEObjects.

jase wrote:

so the OLEObjects collaction comprises all things embedded in
worksheets?

--

Dave Peterson

to complement Dave's thought - all the items on the worksheet are in the
shapes collection.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
Nope. For instance, you can add controls from the Forms toolbar or shapes
from
the Drawing toolbar. These aren't OLEObjects.

jase wrote:

so the OLEObjects collaction comprises all things embedded in
worksheets?

--

Dave Peterson