Aku biasanya pakai cara ini Tekan F5
Click Tombol Special Kemudian pilih objects Click OK Tekan tombol del _____ From: [email protected] [mailto:[email protected]] On Behalf Of STDEV(i) Sent: Thursday, July 15, 2010 7:58 PM To: [email protected] Subject: Re: [belajar-excel] select image (pict) 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] <mailto:hkartiwan%40arahrestu.com> > wrote: > kok gak bisa yehh, dg cara itu. > > Thx > > > From: Syamsudin Syamsudin > Sent: Thursday, July 15, 2010 11:29 AM > To: [email protected] <mailto:belajar-excel%40yahoogroups.com> > 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:belajar-excel%40yahoogroups.com> [mailto:[email protected] <mailto:belajar-excel%40yahoogroups.com> ] > On Behalf Of Haris Kartiwan > Sent: Thursday, July 15, 2010 10:13 AM > To: [email protected] <mailto:belajar-excel%40yahoogroups.com> > 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
