Terimkasih banyak Pak Kid
Pada Rabu, 30 Desember 2015 14:20, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Wa'alaikumussalam wr wb
Hai Hairul,
Coba cari di dalam script, semua yang berbunyi Application.quit diganti dengan
thisworkbook.close false 'kalau tidak ingin disave dulu
atau lakukan save workbook dengan thisworkbook.save sebelum thisworkbook.close
false
Wassalamu'alaikum wr wb
Kid
On Wed, Dec 30, 2015 at 2:14 PM, HAIRUL ALAM [email protected]
[belajar-excel] <[email protected]> wrote:
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
#yiv9978344002 #yiv9978344002 -- #yiv9978344002ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9978344002
#yiv9978344002ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9978344002
#yiv9978344002ygrp-mkp #yiv9978344002hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9978344002 #yiv9978344002ygrp-mkp #yiv9978344002ads
{margin-bottom:10px;}#yiv9978344002 #yiv9978344002ygrp-mkp .yiv9978344002ad
{padding:0 0;}#yiv9978344002 #yiv9978344002ygrp-mkp .yiv9978344002ad p
{margin:0;}#yiv9978344002 #yiv9978344002ygrp-mkp .yiv9978344002ad a
{color:#0000ff;text-decoration:none;}#yiv9978344002 #yiv9978344002ygrp-sponsor
#yiv9978344002ygrp-lc {font-family:Arial;}#yiv9978344002
#yiv9978344002ygrp-sponsor #yiv9978344002ygrp-lc #yiv9978344002hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9978344002
#yiv9978344002ygrp-sponsor #yiv9978344002ygrp-lc .yiv9978344002ad
{margin-bottom:10px;padding:0 0;}#yiv9978344002 #yiv9978344002actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9978344002
#yiv9978344002activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9978344002
#yiv9978344002activity span {font-weight:700;}#yiv9978344002
#yiv9978344002activity span:first-child
{text-transform:uppercase;}#yiv9978344002 #yiv9978344002activity span a
{color:#5085b6;text-decoration:none;}#yiv9978344002 #yiv9978344002activity span
span {color:#ff7900;}#yiv9978344002 #yiv9978344002activity span
.yiv9978344002underline {text-decoration:underline;}#yiv9978344002
.yiv9978344002attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9978344002 .yiv9978344002attach div a
{text-decoration:none;}#yiv9978344002 .yiv9978344002attach img
{border:none;padding-right:5px;}#yiv9978344002 .yiv9978344002attach label
{display:block;margin-bottom:5px;}#yiv9978344002 .yiv9978344002attach label a
{text-decoration:none;}#yiv9978344002 blockquote {margin:0 0 0
4px;}#yiv9978344002 .yiv9978344002bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9978344002
.yiv9978344002bold a {text-decoration:none;}#yiv9978344002 dd.yiv9978344002last
p a {font-family:Verdana;font-weight:700;}#yiv9978344002 dd.yiv9978344002last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9978344002
dd.yiv9978344002last p span.yiv9978344002yshortcuts
{margin-right:0;}#yiv9978344002 div.yiv9978344002attach-table div div a
{text-decoration:none;}#yiv9978344002 div.yiv9978344002attach-table
{width:400px;}#yiv9978344002 div.yiv9978344002file-title a, #yiv9978344002
div.yiv9978344002file-title a:active, #yiv9978344002
div.yiv9978344002file-title a:hover, #yiv9978344002 div.yiv9978344002file-title
a:visited {text-decoration:none;}#yiv9978344002 div.yiv9978344002photo-title a,
#yiv9978344002 div.yiv9978344002photo-title a:active, #yiv9978344002
div.yiv9978344002photo-title a:hover, #yiv9978344002
div.yiv9978344002photo-title a:visited {text-decoration:none;}#yiv9978344002
div#yiv9978344002ygrp-mlmsg #yiv9978344002ygrp-msg p a
span.yiv9978344002yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9978344002
.yiv9978344002green {color:#628c2a;}#yiv9978344002 .yiv9978344002MsoNormal
{margin:0 0 0 0;}#yiv9978344002 o {font-size:0;}#yiv9978344002
#yiv9978344002photos div {float:left;width:72px;}#yiv9978344002
#yiv9978344002photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9978344002
#yiv9978344002photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9978344002
#yiv9978344002reco-category {font-size:77%;}#yiv9978344002
#yiv9978344002reco-desc {font-size:77%;}#yiv9978344002 .yiv9978344002replbq
{margin:4px;}#yiv9978344002 #yiv9978344002ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9978344002 #yiv9978344002ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9978344002
#yiv9978344002ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9978344002
#yiv9978344002ygrp-mlmsg select, #yiv9978344002 input, #yiv9978344002 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9978344002
#yiv9978344002ygrp-mlmsg pre, #yiv9978344002 code {font:115%
monospace;}#yiv9978344002 #yiv9978344002ygrp-mlmsg *
{line-height:1.22em;}#yiv9978344002 #yiv9978344002ygrp-mlmsg #yiv9978344002logo
{padding-bottom:10px;}#yiv9978344002 #yiv9978344002ygrp-msg p a
{font-family:Verdana;}#yiv9978344002 #yiv9978344002ygrp-msg
p#yiv9978344002attach-count span {color:#1E66AE;font-weight:700;}#yiv9978344002
#yiv9978344002ygrp-reco #yiv9978344002reco-head
{color:#ff7900;font-weight:700;}#yiv9978344002 #yiv9978344002ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9978344002 #yiv9978344002ygrp-sponsor
#yiv9978344002ov li a {font-size:130%;text-decoration:none;}#yiv9978344002
#yiv9978344002ygrp-sponsor #yiv9978344002ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9978344002
#yiv9978344002ygrp-sponsor #yiv9978344002ov ul {margin:0;padding:0 0 0
8px;}#yiv9978344002 #yiv9978344002ygrp-text
{font-family:Georgia;}#yiv9978344002 #yiv9978344002ygrp-text p {margin:0 0 1em
0;}#yiv9978344002 #yiv9978344002ygrp-text tt {font-size:120%;}#yiv9978344002
#yiv9978344002ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9978344002
