Dear DD, Gunakan formula event Worksheet_Change() pada sheet yang di tuju.
TerimaKasih
Pada Senin, 18 Mei 2015 11:10, "Dede pmaho_l...@nabatisnack.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear Para Master, Saya punya script seperti ini : Private Sub
Worksheet_Activate() Dim ans As String ans = Sheet13.Range("B8").Value
Sheet13.Activate Range(Cells(12, 2), Cells(ans, 2)).EntireRow.Hidden = False
If Sheet13.Range("B3").Value <> "" And Sheet13.Range("X70").Value > 0 And
Sheet13.Range("AK70").Value > 0 And Sheet13.Range("AX70").Value > 0 Then
Range(Cells(1, 1), Cells(69, 1)).EntireRow.Hidden = False
Range("AL:AX").EntireColumn.Hidden = False Range("Y:AX").EntireColumn.Hidden =
False Range(Cells(ans, 1), Cells(69, 1)).EntireRow.Hidden = True ElseIf
Sheet13.Range("B3").Value <> "" And Sheet13.Range("X70").Value > 0 And
Sheet13.Range("AK70").Value > 0 And Sheet13.Range("AX70").Value = 0 Then
Range(Cells(1, 1), Cells(69, 1)).EntireRow.Hidden = False
Range("Y:AX").EntireColumn.Hidden = False Range("AL:AX").EntireColumn.Hidden =
True Range(Cells(ans, 1), Cells(69, 1)).EntireRow.Hidden = True ElseIf
Sheet13.Range("B3").Value <> "" And Sheet13.Range("X70").Value > 0 And
Sheet13.Range("AK70").Value = 0 And Sheet13.Range("AX70").Value = 0 Then
Range(Cells(1, 1), Cells(69, 1)).EntireRow.Hidden = False
Range("AL:AX").EntireColumn.Hidden = False Range("Y:AX").EntireColumn.Hidden =
True Range(Cells(ans, 1), Cells(69, 1)).EntireRow.Hidden = True Else End If
End Sub Gambar sheet :
File terlalu besar sehingga tidak dapat saya lampirkan. Pertanyaan
saya adalah apa yang harus dirubah pada script VBAnya kalau pada saat saya klik
list pilihan di cell “B3” baris dan kolom terhide otomatis?. Note : report akan
terhide sesuai harapan setelah saya berpindah dahulu ke sheet lain.
Salam, Dede
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.
#yiv1562044114 #yiv1562044114 -- #yiv1562044114ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1562044114
#yiv1562044114ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1562044114
#yiv1562044114ygrp-mkp #yiv1562044114hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1562044114 #yiv1562044114ygrp-mkp #yiv1562044114ads
{margin-bottom:10px;}#yiv1562044114 #yiv1562044114ygrp-mkp .yiv1562044114ad
{padding:0 0;}#yiv1562044114 #yiv1562044114ygrp-mkp .yiv1562044114ad p
{margin:0;}#yiv1562044114 #yiv1562044114ygrp-mkp .yiv1562044114ad a
{color:#0000ff;text-decoration:none;}#yiv1562044114 #yiv1562044114ygrp-sponsor
#yiv1562044114ygrp-lc {font-family:Arial;}#yiv1562044114
#yiv1562044114ygrp-sponsor #yiv1562044114ygrp-lc #yiv1562044114hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1562044114
#yiv1562044114ygrp-sponsor #yiv1562044114ygrp-lc .yiv1562044114ad
{margin-bottom:10px;padding:0 0;}#yiv1562044114 #yiv1562044114actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1562044114
#yiv1562044114activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1562044114
#yiv1562044114activity span {font-weight:700;}#yiv1562044114
#yiv1562044114activity span:first-child
{text-transform:uppercase;}#yiv1562044114 #yiv1562044114activity span a
{color:#5085b6;text-decoration:none;}#yiv1562044114 #yiv1562044114activity span
span {color:#ff7900;}#yiv1562044114 #yiv1562044114activity span
.yiv1562044114underline {text-decoration:underline;}#yiv1562044114
.yiv1562044114attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1562044114 .yiv1562044114attach div a
{text-decoration:none;}#yiv1562044114 .yiv1562044114attach img
{border:none;padding-right:5px;}#yiv1562044114 .yiv1562044114attach label
{display:block;margin-bottom:5px;}#yiv1562044114 .yiv1562044114attach label a
{text-decoration:none;}#yiv1562044114 blockquote {margin:0 0 0
4px;}#yiv1562044114 .yiv1562044114bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1562044114
.yiv1562044114bold a {text-decoration:none;}#yiv1562044114 dd.yiv1562044114last
p a {font-family:Verdana;font-weight:700;}#yiv1562044114 dd.yiv1562044114last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1562044114
dd.yiv1562044114last p span.yiv1562044114yshortcuts
{margin-right:0;}#yiv1562044114 div.yiv1562044114attach-table div div a
{text-decoration:none;}#yiv1562044114 div.yiv1562044114attach-table
{width:400px;}#yiv1562044114 div.yiv1562044114file-title a, #yiv1562044114
div.yiv1562044114file-title a:active, #yiv1562044114
div.yiv1562044114file-title a:hover, #yiv1562044114 div.yiv1562044114file-title
a:visited {text-decoration:none;}#yiv1562044114 div.yiv1562044114photo-title a,
#yiv1562044114 div.yiv1562044114photo-title a:active, #yiv1562044114
div.yiv1562044114photo-title a:hover, #yiv1562044114
div.yiv1562044114photo-title a:visited {text-decoration:none;}#yiv1562044114
div#yiv1562044114ygrp-mlmsg #yiv1562044114ygrp-msg p a
span.yiv1562044114yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1562044114
.yiv1562044114green {color:#628c2a;}#yiv1562044114 .yiv1562044114MsoNormal
{margin:0 0 0 0;}#yiv1562044114 o {font-size:0;}#yiv1562044114
#yiv1562044114photos div {float:left;width:72px;}#yiv1562044114
#yiv1562044114photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1562044114
#yiv1562044114photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1562044114
#yiv1562044114reco-category {font-size:77%;}#yiv1562044114
#yiv1562044114reco-desc {font-size:77%;}#yiv1562044114 .yiv1562044114replbq
{margin:4px;}#yiv1562044114 #yiv1562044114ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1562044114 #yiv1562044114ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1562044114
#yiv1562044114ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1562044114
#yiv1562044114ygrp-mlmsg select, #yiv1562044114 input, #yiv1562044114 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1562044114
#yiv1562044114ygrp-mlmsg pre, #yiv1562044114 code {font:115%
monospace;}#yiv1562044114 #yiv1562044114ygrp-mlmsg *
{line-height:1.22em;}#yiv1562044114 #yiv1562044114ygrp-mlmsg #yiv1562044114logo
{padding-bottom:10px;}#yiv1562044114 #yiv1562044114ygrp-msg p a
{font-family:Verdana;}#yiv1562044114 #yiv1562044114ygrp-msg
p#yiv1562044114attach-count span {color:#1E66AE;font-weight:700;}#yiv1562044114
#yiv1562044114ygrp-reco #yiv1562044114reco-head
{color:#ff7900;font-weight:700;}#yiv1562044114 #yiv1562044114ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1562044114 #yiv1562044114ygrp-sponsor
#yiv1562044114ov li a {font-size:130%;text-decoration:none;}#yiv1562044114
#yiv1562044114ygrp-sponsor #yiv1562044114ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1562044114
#yiv1562044114ygrp-sponsor #yiv1562044114ov ul {margin:0;padding:0 0 0
8px;}#yiv1562044114 #yiv1562044114ygrp-text
{font-family:Georgia;}#yiv1562044114 #yiv1562044114ygrp-text p {margin:0 0 1em
0;}#yiv1562044114 #yiv1562044114ygrp-text tt {font-size:120%;}#yiv1562044114
#yiv1562044114ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1562044114
