Masuk ke VBE (Tekan alt+F11)Menu>insert>module Tulis code spt ini '----- Sub delallshapes() Dim shp as object For each shp in activesheet.shape Shp.delete Next End sub '------- Kembali ke sheet (alt+F11) Jalankan prosedur sub di atas (Tekan alt+F8; pilih nama prosedur; Tekan tombol Run )
On 7/15/10, Haris Kartiwan <[email protected]> wrote: > kok gak bisa yehh, dg cara itu. > > Thx > > > From: Syamsudin Syamsudin > Sent: Thursday, July 15, 2010 11:29 AM > To: [email protected] > Subject: RE: [belajar-excel] select image (pict) > > > > > Caranya cukup select salah satu object (image) lalu teken tombol CTRL + A > kemudian delete .insyaAllah ke hapus semuanya > > > > From: [email protected] [mailto:[email protected]] > On Behalf Of Haris Kartiwan > Sent: Thursday, July 15, 2010 10:13 AM > To: [email protected] > Subject: [belajar-excel] select image (pict) > > > > > > Dear all, > > > > mau nanya nihh, saya pake office 2007 trus Bagaimana caranya untuk select > image yg ada di worksheet, > > soalnya image yg ada di worksheet tsb banyak dan mungkin aja image tsb tidak > terlihat. > > kalo tdk terhapus imagenya, akibatnya size filenya besar sekali,. > > > > mohon tipsnya untuk cara cepat men-select image > > > > Terima Kasih > > Haris > > > > -- Sent from my mobile device
