vba excel: how to copy worksheet with images but without buttons -
i have worksheet image , 2 buttons. (invoice) copy worksheet image without 2 buttons new sheet of new workbook , wanna vba macro. in moment usual copy command , use delete command 2 buttons. i sure there easier way it. tried this... application.copyobjectswithcells = false sheets("invoice").select sheets("invoice").move after:=workbooks("invoices").sheets(1) application.copyobjectswithcells = true these looses buttons image gone. keep image. i hope guys can me this. thanks in advance. the explanations in comments in code below: option explicit sub copysheet_wo_btn() dim newwb workbook dim shtorig worksheet dim obj oleobject dim picshape shape dim picleft double dim pictop double set shtorig = thisworkbook.sheets("invoice") ' loop through objects in "invoice" sheet each obj in s