Assalamualaikum
Yth. Pak Kid
Maksud dari berpengaruh pada file lain, bila saya menutup aplikasi yang
memiliki Vba yang ada saya lampirkan kemarin, file excel yang lain ikut
tertutup, yang artinya harus buka ulang file yang lain tadi Pak, Mohon Maaf
bila penjelasan saya kurang dimengerti
TerimakasihWassalamualaikum
Pada Senin, 28 Desember 2015 6:37, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Wa'alaikumussalam wr wb
Hai Hairul,
Adakah penjelasan yang lebih spesifik tentang 'berpengaruh pada file Excel Lain
yang sedang aktif' ?
Wassalamu'alaikum wr wb
Kid
2015-12-23 10:27 GMT+07:00 HAIRUL ALAM [email protected] [belajar-excel]
<[email protected]>:
Assalamualaikum
Yth. Para Milis Excel
Saya memiliki masalah Close aplikasi Excel yang menggunakan VBA, berpengaruh
pada file Excel Lain yang sedang aktif
Bagaimana mengatasinya agar file excel yang memiliki VBA tersebut bekerja
sendiri dan bila di close file excel yang lain tidak berpengaruh
Terimakasih Banyak
WassalamualaikumHairul Alam
#yiv0197581559 #yiv0197581559 -- #yiv0197581559ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0197581559
#yiv0197581559ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0197581559
#yiv0197581559ygrp-mkp #yiv0197581559hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0197581559 #yiv0197581559ygrp-mkp #yiv0197581559ads
{margin-bottom:10px;}#yiv0197581559 #yiv0197581559ygrp-mkp .yiv0197581559ad
{padding:0 0;}#yiv0197581559 #yiv0197581559ygrp-mkp .yiv0197581559ad p
{margin:0;}#yiv0197581559 #yiv0197581559ygrp-mkp .yiv0197581559ad a
{color:#0000ff;text-decoration:none;}#yiv0197581559 #yiv0197581559ygrp-sponsor
#yiv0197581559ygrp-lc {font-family:Arial;}#yiv0197581559
#yiv0197581559ygrp-sponsor #yiv0197581559ygrp-lc #yiv0197581559hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0197581559
#yiv0197581559ygrp-sponsor #yiv0197581559ygrp-lc .yiv0197581559ad
{margin-bottom:10px;padding:0 0;}#yiv0197581559 #yiv0197581559actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0197581559
#yiv0197581559activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0197581559
#yiv0197581559activity span {font-weight:700;}#yiv0197581559
#yiv0197581559activity span:first-child
{text-transform:uppercase;}#yiv0197581559 #yiv0197581559activity span a
{color:#5085b6;text-decoration:none;}#yiv0197581559 #yiv0197581559activity span
span {color:#ff7900;}#yiv0197581559 #yiv0197581559activity span
.yiv0197581559underline {text-decoration:underline;}#yiv0197581559
.yiv0197581559attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0197581559 .yiv0197581559attach div a
{text-decoration:none;}#yiv0197581559 .yiv0197581559attach img
{border:none;padding-right:5px;}#yiv0197581559 .yiv0197581559attach label
{display:block;margin-bottom:5px;}#yiv0197581559 .yiv0197581559attach label a
{text-decoration:none;}#yiv0197581559 blockquote {margin:0 0 0
4px;}#yiv0197581559 .yiv0197581559bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0197581559
.yiv0197581559bold a {text-decoration:none;}#yiv0197581559 dd.yiv0197581559last
p a {font-family:Verdana;font-weight:700;}#yiv0197581559 dd.yiv0197581559last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0197581559
dd.yiv0197581559last p span.yiv0197581559yshortcuts
{margin-right:0;}#yiv0197581559 div.yiv0197581559attach-table div div a
{text-decoration:none;}#yiv0197581559 div.yiv0197581559attach-table
{width:400px;}#yiv0197581559 div.yiv0197581559file-title a, #yiv0197581559
div.yiv0197581559file-title a:active, #yiv0197581559
div.yiv0197581559file-title a:hover, #yiv0197581559 div.yiv0197581559file-title
a:visited {text-decoration:none;}#yiv0197581559 div.yiv0197581559photo-title a,
#yiv0197581559 div.yiv0197581559photo-title a:active, #yiv0197581559
div.yiv0197581559photo-title a:hover, #yiv0197581559
div.yiv0197581559photo-title a:visited {text-decoration:none;}#yiv0197581559
div#yiv0197581559ygrp-mlmsg #yiv0197581559ygrp-msg p a
span.yiv0197581559yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0197581559
.yiv0197581559green {color:#628c2a;}#yiv0197581559 .yiv0197581559MsoNormal
{margin:0 0 0 0;}#yiv0197581559 o {font-size:0;}#yiv0197581559
#yiv0197581559photos div {float:left;width:72px;}#yiv0197581559
#yiv0197581559photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0197581559
#yiv0197581559photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0197581559
#yiv0197581559reco-category {font-size:77%;}#yiv0197581559
#yiv0197581559reco-desc {font-size:77%;}#yiv0197581559 .yiv0197581559replbq
{margin:4px;}#yiv0197581559 #yiv0197581559ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0197581559 #yiv0197581559ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0197581559
#yiv0197581559ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0197581559
#yiv0197581559ygrp-mlmsg select, #yiv0197581559 input, #yiv0197581559 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0197581559
#yiv0197581559ygrp-mlmsg pre, #yiv0197581559 code {font:115%
monospace;}#yiv0197581559 #yiv0197581559ygrp-mlmsg *
{line-height:1.22em;}#yiv0197581559 #yiv0197581559ygrp-mlmsg #yiv0197581559logo
{padding-bottom:10px;}#yiv0197581559 #yiv0197581559ygrp-msg p a
{font-family:Verdana;}#yiv0197581559 #yiv0197581559ygrp-msg
p#yiv0197581559attach-count span {color:#1E66AE;font-weight:700;}#yiv0197581559
#yiv0197581559ygrp-reco #yiv0197581559reco-head
{color:#ff7900;font-weight:700;}#yiv0197581559 #yiv0197581559ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0197581559 #yiv0197581559ygrp-sponsor
#yiv0197581559ov li a {font-size:130%;text-decoration:none;}#yiv0197581559
#yiv0197581559ygrp-sponsor #yiv0197581559ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0197581559
#yiv0197581559ygrp-sponsor #yiv0197581559ov ul {margin:0;padding:0 0 0
8px;}#yiv0197581559 #yiv0197581559ygrp-text
{font-family:Georgia;}#yiv0197581559 #yiv0197581559ygrp-text p {margin:0 0 1em
0;}#yiv0197581559 #yiv0197581559ygrp-text tt {font-size:120%;}#yiv0197581559
#yiv0197581559ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0197581559
