Dear DD, Berikut Filenya,semoga bisa membantu. TerimaKasih
Pada Selasa, 28 April 2015 15:53, "Dede pmaho_l...@nabatisnack.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear BeExceller, Bisakan sebuah ROW dan COLUMN ter”Hide” otomatis ? Ini
pengembangan kasus hyperlink tadi, semoga teman-teman tidak bosan yah...
Tinggal satu langkah lagi untuk menyempurnakan report terlampir, yaitu dengan
meng”Hide” otomatis baris kosong di sheet “View” dan kolom yang tidak ada
datanya pada saat saya klik kode subdist di sheet “List Kirim GT” apakah hal
itu memungkinkan ? Mohon pencerahannya dari para master sekalian. Salam, DD
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed. If you have
received this email in error please send it back to the person that sent it to
you. Any views or opinions presented are solely those of its author and do not
necessarily represent those of NABATI or any of its subsidiary companies.
Unauthorized publication, use, dissemination, forwarding, printing or copying
of this email and its associated attachments is strictly prohibited.
#yiv2362484861 #yiv2362484861 -- #yiv2362484861ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2362484861
#yiv2362484861ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2362484861
#yiv2362484861ygrp-mkp #yiv2362484861hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2362484861 #yiv2362484861ygrp-mkp #yiv2362484861ads
{margin-bottom:10px;}#yiv2362484861 #yiv2362484861ygrp-mkp .yiv2362484861ad
{padding:0 0;}#yiv2362484861 #yiv2362484861ygrp-mkp .yiv2362484861ad p
{margin:0;}#yiv2362484861 #yiv2362484861ygrp-mkp .yiv2362484861ad a
{color:#0000ff;text-decoration:none;}#yiv2362484861 #yiv2362484861ygrp-sponsor
#yiv2362484861ygrp-lc {font-family:Arial;}#yiv2362484861
#yiv2362484861ygrp-sponsor #yiv2362484861ygrp-lc #yiv2362484861hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2362484861
#yiv2362484861ygrp-sponsor #yiv2362484861ygrp-lc .yiv2362484861ad
{margin-bottom:10px;padding:0 0;}#yiv2362484861 #yiv2362484861actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2362484861
#yiv2362484861activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2362484861
#yiv2362484861activity span {font-weight:700;}#yiv2362484861
#yiv2362484861activity span:first-child
{text-transform:uppercase;}#yiv2362484861 #yiv2362484861activity span a
{color:#5085b6;text-decoration:none;}#yiv2362484861 #yiv2362484861activity span
span {color:#ff7900;}#yiv2362484861 #yiv2362484861activity span
.yiv2362484861underline {text-decoration:underline;}#yiv2362484861
.yiv2362484861attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2362484861 .yiv2362484861attach div a
{text-decoration:none;}#yiv2362484861 .yiv2362484861attach img
{border:none;padding-right:5px;}#yiv2362484861 .yiv2362484861attach label
{display:block;margin-bottom:5px;}#yiv2362484861 .yiv2362484861attach label a
{text-decoration:none;}#yiv2362484861 blockquote {margin:0 0 0
4px;}#yiv2362484861 .yiv2362484861bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2362484861
.yiv2362484861bold a {text-decoration:none;}#yiv2362484861 dd.yiv2362484861last
p a {font-family:Verdana;font-weight:700;}#yiv2362484861 dd.yiv2362484861last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2362484861
dd.yiv2362484861last p span.yiv2362484861yshortcuts
{margin-right:0;}#yiv2362484861 div.yiv2362484861attach-table div div a
{text-decoration:none;}#yiv2362484861 div.yiv2362484861attach-table
{width:400px;}#yiv2362484861 div.yiv2362484861file-title a, #yiv2362484861
div.yiv2362484861file-title a:active, #yiv2362484861
div.yiv2362484861file-title a:hover, #yiv2362484861 div.yiv2362484861file-title
a:visited {text-decoration:none;}#yiv2362484861 div.yiv2362484861photo-title a,
#yiv2362484861 div.yiv2362484861photo-title a:active, #yiv2362484861
div.yiv2362484861photo-title a:hover, #yiv2362484861
div.yiv2362484861photo-title a:visited {text-decoration:none;}#yiv2362484861
div#yiv2362484861ygrp-mlmsg #yiv2362484861ygrp-msg p a
span.yiv2362484861yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2362484861
.yiv2362484861green {color:#628c2a;}#yiv2362484861 .yiv2362484861MsoNormal
{margin:0 0 0 0;}#yiv2362484861 o {font-size:0;}#yiv2362484861
#yiv2362484861photos div {float:left;width:72px;}#yiv2362484861
#yiv2362484861photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2362484861
#yiv2362484861photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2362484861
#yiv2362484861reco-category {font-size:77%;}#yiv2362484861
#yiv2362484861reco-desc {font-size:77%;}#yiv2362484861 .yiv2362484861replbq
{margin:4px;}#yiv2362484861 #yiv2362484861ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2362484861 #yiv2362484861ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2362484861
#yiv2362484861ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2362484861
#yiv2362484861ygrp-mlmsg select, #yiv2362484861 input, #yiv2362484861 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2362484861
#yiv2362484861ygrp-mlmsg pre, #yiv2362484861 code {font:115%
monospace;}#yiv2362484861 #yiv2362484861ygrp-mlmsg *
{line-height:1.22em;}#yiv2362484861 #yiv2362484861ygrp-mlmsg #yiv2362484861logo
{padding-bottom:10px;}#yiv2362484861 #yiv2362484861ygrp-msg p a
{font-family:Verdana;}#yiv2362484861 #yiv2362484861ygrp-msg
p#yiv2362484861attach-count span {color:#1E66AE;font-weight:700;}#yiv2362484861
#yiv2362484861ygrp-reco #yiv2362484861reco-head
{color:#ff7900;font-weight:700;}#yiv2362484861 #yiv2362484861ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2362484861 #yiv2362484861ygrp-sponsor
#yiv2362484861ov li a {font-size:130%;text-decoration:none;}#yiv2362484861
#yiv2362484861ygrp-sponsor #yiv2362484861ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2362484861
#yiv2362484861ygrp-sponsor #yiv2362484861ov ul {margin:0;padding:0 0 0
8px;}#yiv2362484861 #yiv2362484861ygrp-text
{font-family:Georgia;}#yiv2362484861 #yiv2362484861ygrp-text p {margin:0 0 1em
0;}#yiv2362484861 #yiv2362484861ygrp-text tt {font-size:120%;}#yiv2362484861
#yiv2362484861ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2362484861
Copy of Hyperlink_TOBY.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
