Terima kasih banyak Pak HK...Kadang sering juga bekerja dengan workbook excel yang panjang sheet nya mirip kereta Babaranjang (Batu Bara Rangkaian Panjang) :) Salam. - prodev simple -
Pada Rabu, 19 November 2014 11:55, "hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Dalam Excel, kadang2 kita bekerja dengan banyak sheet.Untuk memilih sheet secara cepat kita bisa membuat Daftar Sheet dengan link, seperti yang pernah ditampilkan dalam blog B-Excel. Ada alternatif lain yang saya dapat dari internet, dengan mengaktifkan macro berikut ini :Sub PilihSheet() Application.CommandBars("Workbook tabs").ShowPopupEnd Sub Pada saat macro diaktifkan akan tampil seluruh sheet yang ada dalam bentuk Pop Up.Kita tinggal memilih sheet, kemudian kita akan langsung diarahkan ke sheet tsb. Salam,HK <!--#yiv5190211674 #yiv5190211674ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5190211674 #yiv5190211674ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5190211674 #yiv5190211674ygrp-mkp #yiv5190211674hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5190211674 #yiv5190211674ygrp-mkp #yiv5190211674ads {margin-bottom:10px;}#yiv5190211674 #yiv5190211674ygrp-mkp .yiv5190211674ad {padding:0 0;}#yiv5190211674 #yiv5190211674ygrp-mkp .yiv5190211674ad p {margin:0;}#yiv5190211674 #yiv5190211674ygrp-mkp .yiv5190211674ad a {color:#0000ff;text-decoration:none;}#yiv5190211674 #yiv5190211674ygrp-sponsor #yiv5190211674ygrp-lc {font-family:Arial;}#yiv5190211674 #yiv5190211674ygrp-sponsor #yiv5190211674ygrp-lc #yiv5190211674hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5190211674 #yiv5190211674ygrp-sponsor #yiv5190211674ygrp-lc .yiv5190211674ad {margin-bottom:10px;padding:0 0;}#yiv5190211674 #yiv5190211674actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5190211674 #yiv5190211674activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5190211674 #yiv5190211674activity span {font-weight:700;}#yiv5190211674 #yiv5190211674activity span:first-child {text-transform:uppercase;}#yiv5190211674 #yiv5190211674activity span a {color:#5085b6;text-decoration:none;}#yiv5190211674 #yiv5190211674activity span span {color:#ff7900;}#yiv5190211674 #yiv5190211674activity span .yiv5190211674underline {text-decoration:underline;}#yiv5190211674 .yiv5190211674attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5190211674 .yiv5190211674attach div a {text-decoration:none;}#yiv5190211674 .yiv5190211674attach img {border:none;padding-right:5px;}#yiv5190211674 .yiv5190211674attach label {display:block;margin-bottom:5px;}#yiv5190211674 .yiv5190211674attach label a {text-decoration:none;}#yiv5190211674 blockquote {margin:0 0 0 4px;}#yiv5190211674 .yiv5190211674bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5190211674 .yiv5190211674bold a {text-decoration:none;}#yiv5190211674 dd.yiv5190211674last p a {font-family:Verdana;font-weight:700;}#yiv5190211674 dd.yiv5190211674last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5190211674 dd.yiv5190211674last p span.yiv5190211674yshortcuts {margin-right:0;}#yiv5190211674 div.yiv5190211674attach-table div div a {text-decoration:none;}#yiv5190211674 div.yiv5190211674attach-table {width:400px;}#yiv5190211674 div.yiv5190211674file-title a, #yiv5190211674 div.yiv5190211674file-title a:active, #yiv5190211674 div.yiv5190211674file-title a:hover, #yiv5190211674 div.yiv5190211674file-title a:visited {text-decoration:none;}#yiv5190211674 div.yiv5190211674photo-title a, #yiv5190211674 div.yiv5190211674photo-title a:active, #yiv5190211674 div.yiv5190211674photo-title a:hover, #yiv5190211674 div.yiv5190211674photo-title a:visited {text-decoration:none;}#yiv5190211674 div#yiv5190211674ygrp-mlmsg #yiv5190211674ygrp-msg p a span.yiv5190211674yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5190211674 .yiv5190211674green {color:#628c2a;}#yiv5190211674 .yiv5190211674MsoNormal {margin:0 0 0 0;}#yiv5190211674 o {font-size:0;}#yiv5190211674 #yiv5190211674photos div {float:left;width:72px;}#yiv5190211674 #yiv5190211674photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5190211674 #yiv5190211674photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5190211674 #yiv5190211674reco-category {font-size:77%;}#yiv5190211674 #yiv5190211674reco-desc {font-size:77%;}#yiv5190211674 .yiv5190211674replbq {margin:4px;}#yiv5190211674 #yiv5190211674ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5190211674 #yiv5190211674ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5190211674 #yiv5190211674ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5190211674 #yiv5190211674ygrp-mlmsg select, #yiv5190211674 input, #yiv5190211674 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5190211674 #yiv5190211674ygrp-mlmsg pre, #yiv5190211674 code {font:115% monospace;}#yiv5190211674 #yiv5190211674ygrp-mlmsg * {line-height:1.22em;}#yiv5190211674 #yiv5190211674ygrp-mlmsg #yiv5190211674logo {padding-bottom:10px;}#yiv5190211674 #yiv5190211674ygrp-msg p a {font-family:Verdana;}#yiv5190211674 #yiv5190211674ygrp-msg p#yiv5190211674attach-count span {color:#1E66AE;font-weight:700;}#yiv5190211674 #yiv5190211674ygrp-reco #yiv5190211674reco-head {color:#ff7900;font-weight:700;}#yiv5190211674 #yiv5190211674ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5190211674 #yiv5190211674ygrp-sponsor #yiv5190211674ov li a {font-size:130%;text-decoration:none;}#yiv5190211674 #yiv5190211674ygrp-sponsor #yiv5190211674ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5190211674 #yiv5190211674ygrp-sponsor #yiv5190211674ov ul {margin:0;padding:0 0 0 8px;}#yiv5190211674 #yiv5190211674ygrp-text {font-family:Georgia;}#yiv5190211674 #yiv5190211674ygrp-text p {margin:0 0 1em 0;}#yiv5190211674 #yiv5190211674ygrp-text tt {font-size:120%;}#yiv5190211674 #yiv5190211674ygrp-vital ul li:last-child {border-right:none !important;}-->