Re: [belajar-excel] Double Klik Path untuk 2 Cell

2019-08-25 Terurut Topik Yusuf Roni y.ron...@yahoo.com [belajar-excel] 
 Dear Mr Kid,

Terimakasih jawabanya. Luar Biasa.

Regards,Roni
Pada Minggu, 25 Agustus 2019 16.04.49 GMT+8, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel]  menulis:

  

buang kode yang begini ini..        If Selection.Column <> 4 Or Selection.Row < 
2 Then
            MsgBox "Please select a cell from Column D for your corresponding 
email Row", vbInformation, "LearnExcelMacro.com"
            Exit Sub
        End If

itu gak ada gunanya karena gak sesuai dengan keadaan setempat



On Fri, Aug 23, 2019 at 11:15 AM y.ron...@yahoo.com [belajar-excel] 
 wrote:

     


Dear All,




Mohon dibantu untuk Double Klik Path untuk 2 Cell.

Pada D5 didouble klik untuk mendapatkan path bisa. Mohon dibantu untuk script 
pada E5?

Terlampir Filenya

Terimakasih










Regards,

Roni



  #yiv5425011773 #yiv5425011773 -- #yiv5425011773ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5425011773 
#yiv5425011773ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5425011773 
#yiv5425011773ygrp-mkp #yiv5425011773hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv5425011773 #yiv5425011773ygrp-mkp #yiv5425011773ads 
{margin-bottom:10px;}#yiv5425011773 #yiv5425011773ygrp-mkp .yiv5425011773ad 
{padding:0 0;}#yiv5425011773 #yiv5425011773ygrp-mkp .yiv5425011773ad p 
{margin:0;}#yiv5425011773 #yiv5425011773ygrp-mkp .yiv5425011773ad a 
{color:#ff;text-decoration:none;}#yiv5425011773 #yiv5425011773ygrp-sponsor 
#yiv5425011773ygrp-lc {font-family:Arial;}#yiv5425011773 
#yiv5425011773ygrp-sponsor #yiv5425011773ygrp-lc #yiv5425011773hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5425011773 
#yiv5425011773ygrp-sponsor #yiv5425011773ygrp-lc .yiv5425011773ad 
{margin-bottom:10px;padding:0 0;}#yiv5425011773 #yiv5425011773actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5425011773 
#yiv5425011773activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5425011773
 #yiv5425011773activity span {font-weight:700;}#yiv5425011773 
#yiv5425011773activity span:first-child 
{text-transform:uppercase;}#yiv5425011773 #yiv5425011773activity span a 
{color:#5085b6;text-decoration:none;}#yiv5425011773 #yiv5425011773activity span 
span {color:#ff7900;}#yiv5425011773 #yiv5425011773activity span 
.yiv5425011773underline {text-decoration:underline;}#yiv5425011773 
.yiv5425011773attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv5425011773 .yiv5425011773attach div a 
{text-decoration:none;}#yiv5425011773 .yiv5425011773attach img 
{border:none;padding-right:5px;}#yiv5425011773 .yiv5425011773attach label 
{display:block;margin-bottom:5px;}#yiv5425011773 .yiv5425011773attach label a 
{text-decoration:none;}#yiv5425011773 blockquote {margin:0 0 0 
4px;}#yiv5425011773 .yiv5425011773bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5425011773 
.yiv5425011773bold a {text-decoration:none;}#yiv5425011773 dd.yiv5425011773last 
p a {font-family:Verdana;font-weight:700;}#yiv5425011773 dd.yiv5425011773last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5425011773 
dd.yiv5425011773last p span.yiv5425011773yshortcuts 
{margin-right:0;}#yiv5425011773 div.yiv5425011773attach-table div div a 
{text-decoration:none;}#yiv5425011773 div.yiv5425011773attach-table 
{width:400px;}#yiv5425011773 div.yiv5425011773file-title a, #yiv5425011773 
div.yiv5425011773file-title a:active, #yiv5425011773 
div.yiv5425011773file-title a:hover, #yiv5425011773 div.yiv5425011773file-title 
a:visited {text-decoration:none;}#yiv5425011773 div.yiv5425011773photo-title a, 
#yiv5425011773 div.yiv5425011773photo-title a:active, #yiv5425011773 
div.yiv5425011773photo-title a:hover, #yiv5425011773 
div.yiv5425011773photo-title a:visited {text-decoration:none;}#yiv5425011773 
div#yiv5425011773ygrp-mlmsg #yiv5425011773ygrp-msg p a 
span.yiv5425011773yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5425011773 
.yiv5425011773green {color:#628c2a;}#yiv5425011773 .yiv5425011773MsoNormal 
{margin:0 0 0 0;}#yiv5425011773 o {font-size:0;}#yiv5425011773 
#yiv5425011773photos div {float:left;width:72px;}#yiv5425011773 
#yiv5425011773photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv5425011773 
#yiv5425011773photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5425011773
 #yiv5425011773reco-category {font-size:77%;}#yiv5425011773 
#yiv5425011773reco-desc {font-size:77%;}#yiv5425011773 .yiv5425011773replbq 
{margin:4px;}#yiv5425011773 #yiv5425011773ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv5425011773 #yiv5425011773ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5425011773 
#yiv5425011773ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5425011773 
#yiv5425011773ygrp-mlmsg select, #yiv5425011773

Re: [belajar-excel] Mohon Dibantu untuk script Expired Date Macro

2018-04-16 Terurut Topik Yusuf Roni y.ron...@yahoo.com [belajar-excel] 
 ditempat saya tidak muncul debug. bgmn dong mau masuk ke scriptnya???
Pada Senin, 16 April 2018 17.38.32 WITA, hendrik karnadi 
hendrikkarn...@yahoo.com [belajar-excel]  
menulis:

  
Saya sdh coba buka...
Waktu keluar pesan "This Wokrksheet was valid until 31/08/2009 and will be 
closed" klik Ok.Ketika keluar "Run-time error '91':"...klik Debug.Ganti tahun 
dari 2009 ke 2018, kmd klik Reset (icon kotak di bagian atas) untuk membatalkan 
Debug.
Setelah itu tombol "Input Data" siap digunakan.
Selamat mencoba
Salam,HK

Sent from Yahoo Mail on Android

  On Mon, Apr 16, 2018 at 15:25, y.ron...@yahoo.com 
[belajar-excel] wrote:    
untuk scriptnya sudah saya buat hanya saya tidak bisa buka lagi. adakah scrip 
ketika sudah expired maka ketika di aktifkan harus memasukkan serial sehingga 
bisa diaktifkan kembali?
 
  #yiv4521808571 #yiv4521808571 -- #yiv4521808571ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4521808571 
#yiv4521808571ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4521808571 
#yiv4521808571ygrp-mkp #yiv4521808571hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv4521808571 #yiv4521808571ygrp-mkp #yiv4521808571ads 
{margin-bottom:10px;}#yiv4521808571 #yiv4521808571ygrp-mkp .yiv4521808571ad 
{padding:0 0;}#yiv4521808571 #yiv4521808571ygrp-mkp .yiv4521808571ad p 
{margin:0;}#yiv4521808571 #yiv4521808571ygrp-mkp .yiv4521808571ad a 
{color:#ff;text-decoration:none;}#yiv4521808571 #yiv4521808571ygrp-sponsor 
#yiv4521808571ygrp-lc {font-family:Arial;}#yiv4521808571 
#yiv4521808571ygrp-sponsor #yiv4521808571ygrp-lc #yiv4521808571hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4521808571 
#yiv4521808571ygrp-sponsor #yiv4521808571ygrp-lc .yiv4521808571ad 
{margin-bottom:10px;padding:0 0;}#yiv4521808571 #yiv4521808571actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4521808571 
#yiv4521808571activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4521808571
 #yiv4521808571activity span {font-weight:700;}#yiv4521808571 
#yiv4521808571activity span:first-child 
{text-transform:uppercase;}#yiv4521808571 #yiv4521808571activity span a 
{color:#5085b6;text-decoration:none;}#yiv4521808571 #yiv4521808571activity span 
span {color:#ff7900;}#yiv4521808571 #yiv4521808571activity span 
.yiv4521808571underline {text-decoration:underline;}#yiv4521808571 
.yiv4521808571attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv4521808571 .yiv4521808571attach div a 
{text-decoration:none;}#yiv4521808571 .yiv4521808571attach img 
{border:none;padding-right:5px;}#yiv4521808571 .yiv4521808571attach label 
{display:block;margin-bottom:5px;}#yiv4521808571 .yiv4521808571attach label a 
{text-decoration:none;}#yiv4521808571 blockquote {margin:0 0 0 
4px;}#yiv4521808571 .yiv4521808571bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4521808571 
.yiv4521808571bold a {text-decoration:none;}#yiv4521808571 dd.yiv4521808571last 
p a {font-family:Verdana;font-weight:700;}#yiv4521808571 dd.yiv4521808571last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4521808571 
dd.yiv4521808571last p span.yiv4521808571yshortcuts 
{margin-right:0;}#yiv4521808571 div.yiv4521808571attach-table div div a 
{text-decoration:none;}#yiv4521808571 div.yiv4521808571attach-table 
{width:400px;}#yiv4521808571 div.yiv4521808571file-title a, #yiv4521808571 
div.yiv4521808571file-title a:active, #yiv4521808571 
div.yiv4521808571file-title a:hover, #yiv4521808571 div.yiv4521808571file-title 
a:visited {text-decoration:none;}#yiv4521808571 div.yiv4521808571photo-title a, 
#yiv4521808571 div.yiv4521808571photo-title a:active, #yiv4521808571 
div.yiv4521808571photo-title a:hover, #yiv4521808571 
div.yiv4521808571photo-title a:visited {text-decoration:none;}#yiv4521808571 
div#yiv4521808571ygrp-mlmsg #yiv4521808571ygrp-msg p a 
span.yiv4521808571yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4521808571 
.yiv4521808571green {color:#628c2a;}#yiv4521808571 .yiv4521808571MsoNormal 
{margin:0 0 0 0;}#yiv4521808571 o {font-size:0;}#yiv4521808571 
#yiv4521808571photos div {float:left;width:72px;}#yiv4521808571 
#yiv4521808571photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv4521808571 
#yiv4521808571photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4521808571
 #yiv4521808571reco-category {font-size:77%;}#yiv4521808571 
#yiv4521808571reco-desc {font-size:77%;}#yiv4521808571 .yiv4521808571replbq 
{margin:4px;}#yiv4521808571 #yiv4521808571ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv4521808571 #yiv4521808571ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4521808571 
#yiv4521808571ygrp-mlmsg