Kalau mau menghapus shapes di semua Sheets sekaligus maka codingnya adalah spt
ini : Sub hapus_shape()
Dim wsh As Worksheet Dim sh As Shape 'Set wsh
= Worksheets("nama sheet") For Each wsh In ThisWorkbook.Worksheets
For Each sh In wsh.Shapes sh.Delete
Next Next End Sub
Salam,HK
Catatan: Coding warna hijau diganti dengan yang biru
----- Forwarded Message -----
From: "hendrik karnadi [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, 29 November 2016, 10:19
Subject: Re: [belajar-excel] proses input, pindah Sheet dan Edit pada excel
2007 lambat
Saya pernah mengalami kasus serupa, dimana ada begitu banyak shape yang
tidak terlihat secara kasat mata.
Coba lakukan langkah ini :- Cek apakah waktu loading ada "Add-In".- Hapus baris
atau kolom kosong di semua Sheets.- Cek apakah ada peringatan circular
reference.- Value formula yang tidak perlu sebagai formula termasuk link
formula- Kurangi Format yang tidak perlu.- Hapus Shape pada Sheet dengan Macro
berikut ini : Sub hapus_shape() Dim wsh As Worksheet Dim
sh As Shape Set wsh = Worksheets("nama sheet") For Each sh In
wsh.Shapes sh.Delete Next End Sub
Kalau ga berhasil juga, coba buat workbook baru dan copy masing2 sheet sebatas
yang ada isinya saja. SImpan dengan nama file baru (Kalau mau boleh langsung
lakukan langkah ini)/
Salam,HK
From: "Agus Salim Al Ghozali [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Tuesday, 29 November 2016, 9:40
Subject: [belajar-excel] proses input, pindah Sheet dan Edit pada excel 2007
lambat
Dear Mas, Mohon bantuan Mas, File Excel saya loadingnya sangat lambat
setelah saya tambah rows, jadi untuk input data, edit data dan pindah sheet
jadi lambat mas. terimakasih sebelumnya salam agus salim Nst
#yiv5648868616 #yiv5648868616 -- #yiv5648868616ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5648868616
#yiv5648868616ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5648868616
#yiv5648868616ygrp-mkp #yiv5648868616hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5648868616 #yiv5648868616ygrp-mkp #yiv5648868616ads
{margin-bottom:10px;}#yiv5648868616 #yiv5648868616ygrp-mkp .yiv5648868616ad
{padding:0 0;}#yiv5648868616 #yiv5648868616ygrp-mkp .yiv5648868616ad p
{margin:0;}#yiv5648868616 #yiv5648868616ygrp-mkp .yiv5648868616ad a
{color:#0000ff;text-decoration:none;}#yiv5648868616 #yiv5648868616ygrp-sponsor
#yiv5648868616ygrp-lc {font-family:Arial;}#yiv5648868616
#yiv5648868616ygrp-sponsor #yiv5648868616ygrp-lc #yiv5648868616hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5648868616
#yiv5648868616ygrp-sponsor #yiv5648868616ygrp-lc .yiv5648868616ad
{margin-bottom:10px;padding:0 0;}#yiv5648868616 #yiv5648868616actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5648868616
#yiv5648868616activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5648868616
#yiv5648868616activity span {font-weight:700;}#yiv5648868616
#yiv5648868616activity span:first-child
{text-transform:uppercase;}#yiv5648868616 #yiv5648868616activity span a
{color:#5085b6;text-decoration:none;}#yiv5648868616 #yiv5648868616activity span
span {color:#ff7900;}#yiv5648868616 #yiv5648868616activity span
.yiv5648868616underline {text-decoration:underline;}#yiv5648868616
.yiv5648868616attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5648868616 .yiv5648868616attach div a
{text-decoration:none;}#yiv5648868616 .yiv5648868616attach img
{border:none;padding-right:5px;}#yiv5648868616 .yiv5648868616attach label
{display:block;margin-bottom:5px;}#yiv5648868616 .yiv5648868616attach label a
{text-decoration:none;}#yiv5648868616 blockquote {margin:0 0 0
4px;}#yiv5648868616 .yiv5648868616bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5648868616
.yiv5648868616bold a {text-decoration:none;}#yiv5648868616 dd.yiv5648868616last
p a {font-family:Verdana;font-weight:700;}#yiv5648868616 dd.yiv5648868616last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5648868616
dd.yiv5648868616last p span.yiv5648868616yshortcuts
{margin-right:0;}#yiv5648868616 div.yiv5648868616attach-table div div a
{text-decoration:none;}#yiv5648868616 div.yiv5648868616attach-table
{width:400px;}#yiv5648868616 div.yiv5648868616file-title a, #yiv5648868616
div.yiv5648868616file-title a:active, #yiv5648868616
div.yiv5648868616file-title a:hover, #yiv5648868616 div.yiv5648868616file-title
a:visited {text-decoration:none;}#yiv5648868616 div.yiv5648868616photo-title a,
#yiv5648868616 div.yiv5648868616photo-title a:active, #yiv5648868616
div.yiv5648868616photo-title a:hover, #yiv5648868616
div.yiv5648868616photo-title a:visited {text-decoration:none;}#yiv5648868616
div#yiv5648868616ygrp-mlmsg #yiv5648868616ygrp-msg p a
span.yiv5648868616yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5648868616
.yiv5648868616green {color:#628c2a;}#yiv5648868616 .yiv5648868616MsoNormal
{margin:0 0 0 0;}#yiv5648868616 o {font-size:0;}#yiv5648868616
#yiv5648868616photos div {float:left;width:72px;}#yiv5648868616
#yiv5648868616photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5648868616
#yiv5648868616photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5648868616
#yiv5648868616reco-category {font-size:77%;}#yiv5648868616
#yiv5648868616reco-desc {font-size:77%;}#yiv5648868616 .yiv5648868616replbq
{margin:4px;}#yiv5648868616 #yiv5648868616ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5648868616 #yiv5648868616ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5648868616
#yiv5648868616ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5648868616
#yiv5648868616ygrp-mlmsg select, #yiv5648868616 input, #yiv5648868616 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5648868616
#yiv5648868616ygrp-mlmsg pre, #yiv5648868616 code {font:115%
monospace;}#yiv5648868616 #yiv5648868616ygrp-mlmsg *
{line-height:1.22em;}#yiv5648868616 #yiv5648868616ygrp-mlmsg #yiv5648868616logo
{padding-bottom:10px;}#yiv5648868616 #yiv5648868616ygrp-msg p a
{font-family:Verdana;}#yiv5648868616 #yiv5648868616ygrp-msg
p#yiv5648868616attach-count span {color:#1E66AE;font-weight:700;}#yiv5648868616
#yiv5648868616ygrp-reco #yiv5648868616reco-head
{color:#ff7900;font-weight:700;}#yiv5648868616 #yiv5648868616ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5648868616 #yiv5648868616ygrp-sponsor
#yiv5648868616ov li a {font-size:130%;text-decoration:none;}#yiv5648868616
#yiv5648868616ygrp-sponsor #yiv5648868616ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5648868616
#yiv5648868616ygrp-sponsor #yiv5648868616ov ul {margin:0;padding:0 0 0
8px;}#yiv5648868616 #yiv5648868616ygrp-text
{font-family:Georgia;}#yiv5648868616 #yiv5648868616ygrp-text p {margin:0 0 1em
0;}#yiv5648868616 #yiv5648868616ygrp-text tt {font-size:120%;}#yiv5648868616
#yiv5648868616ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5648868616
