Re: ]] XL-mania [[ blok sekaligus

[rivo]

On 25/08/2013 2:16, hendrik karnadi wrote:

Kalau pengertian memblok (untuk dihapus) gambar (=shape) maka bisa pake macro ini:

Sub hapus_shape()
 Dim sh As Shape
For Each sh In Sheet1.Shapes
        sh.Delete
    Next
    MsgBox "Semua shape sudah dihapus", vbInformation, "Informasi"
End Sub

Asumsi semua shape ada di Sheet1.

Salam,
hk

*From:* rivo <rivo...@gmail.com>
*To:* XL-mania@yahoogroups.com
*Sent:* Sunday, 18 August 2013, 20:48
*Subject:* ]] XL-mania [[ blok sekaligus

Dear para master,
langsung aja yach...gimana caranya memblok sekaligus
beberapa gambar atau drawing di Excel.

thanks
Rivo

Kalau mau hapus sekaligus gambar di excel gunakan tombol CTRL + 6

thanks
Rivo