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
[email protected] [belajar-excel]" <[email protected]>
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;}-->
