Thread: Delete a Commandbutton from another Workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Delete a Commandbutton from another Workbook
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



Reply With QuoteReply With Quote