Hai DD,Kalau mau aman memang sebaiknya ketiganya dijadikan "bagian pembukaan" (setelah Option Explicit dan deklarasi variable) dan "bagian penutupan" (sebelum End Sub). Salam,HK
Sent from Yahoo Mail on Android On Thu, Jul 19, 2018 at 20:32, 'Dede Sulaeman' pmaho_...@pinusmerahabadi.co.id [belajar-excel]<belajar-excel@yahoogroups.com> wrote: Dear Mr Kid, Ya ampuun, dari ketiga ini : Application.ScreenUpdating = False Application.EnableEvents = False Application.DisplayAlerts = False hanya Application.EnableEvents = False yang tidak saya gunakan makanya selalu keluar notif. Hehehe… Terima kasih Mr Kid atas masukannya. Salam, DD From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] Sent: Thursday, July 19, 2018 4:18 PM To: BeExcel Subject: Re: [belajar-excel] Hilangkan Notifikasi Application.ScreenUpdating = False Application.EnableEvents = False Application.DisplayAlerts = False baris kode Application.ScreenUpdating = False Application.EnableEvents = False Application.DisplayAlerts = False 2018-07-19 14:31 GMT+07:00 'Dede Sulaeman' pmaho_...@pinusmerahabadi.co.id [belajar-excel] <belajar-excel@yahoogroups.com>: Dear BeExceller, Mohon masukannya buat temen-temen. Saya ada kasus seperti ini : Saya punya file DATABASE, file ini akan mengumpulkan data dari FILE_1 dan FILE_2. Di FILE_1 dan FILE_2 ada perintah seperti ini : Private Sub Workbook_BeforeClose(Cancel As Boolean) If MsgBox("Apakah Anda sudah melakukan cross?" & vbCrLf & "Jika belum pilih Tombol 'NO'", vbQuestion + vbYesNo) = vbNo Then Cancel = True Sheets("Rekap per Sales").Select Range("J67").Select End If End Sub Otomatis ketika saya menjalankan macro di file DATABASE muncul pesan seperti diatas saat ada perintah “Close FILE_1”. Pertanyaannya adalah, bagaimana menghilangkan notifikasi tersebut. Salam, DD #yiv4752287157 #yiv4752287157 -- #yiv4752287157ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4752287157 #yiv4752287157ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4752287157 #yiv4752287157ygrp-mkp #yiv4752287157hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4752287157 #yiv4752287157ygrp-mkp #yiv4752287157ads {margin-bottom:10px;}#yiv4752287157 #yiv4752287157ygrp-mkp .yiv4752287157ad {padding:0 0;}#yiv4752287157 #yiv4752287157ygrp-mkp .yiv4752287157ad p {margin:0;}#yiv4752287157 #yiv4752287157ygrp-mkp .yiv4752287157ad a {color:#0000ff;text-decoration:none;}#yiv4752287157 #yiv4752287157ygrp-sponsor #yiv4752287157ygrp-lc {font-family:Arial;}#yiv4752287157 #yiv4752287157ygrp-sponsor #yiv4752287157ygrp-lc #yiv4752287157hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4752287157 #yiv4752287157ygrp-sponsor #yiv4752287157ygrp-lc .yiv4752287157ad {margin-bottom:10px;padding:0 0;}#yiv4752287157 #yiv4752287157actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4752287157 #yiv4752287157activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4752287157 #yiv4752287157activity span {font-weight:700;}#yiv4752287157 #yiv4752287157activity span:first-child {text-transform:uppercase;}#yiv4752287157 #yiv4752287157activity span a {color:#5085b6;text-decoration:none;}#yiv4752287157 #yiv4752287157activity span span {color:#ff7900;}#yiv4752287157 #yiv4752287157activity span .yiv4752287157underline {text-decoration:underline;}#yiv4752287157 .yiv4752287157attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4752287157 .yiv4752287157attach div a {text-decoration:none;}#yiv4752287157 .yiv4752287157attach img {border:none;padding-right:5px;}#yiv4752287157 .yiv4752287157attach label {display:block;margin-bottom:5px;}#yiv4752287157 .yiv4752287157attach label a {text-decoration:none;}#yiv4752287157 blockquote {margin:0 0 0 4px;}#yiv4752287157 .yiv4752287157bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4752287157 .yiv4752287157bold a {text-decoration:none;}#yiv4752287157 dd.yiv4752287157last p a {font-family:Verdana;font-weight:700;}#yiv4752287157 dd.yiv4752287157last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4752287157 dd.yiv4752287157last p span.yiv4752287157yshortcuts {margin-right:0;}#yiv4752287157 div.yiv4752287157attach-table div div a {text-decoration:none;}#yiv4752287157 div.yiv4752287157attach-table {width:400px;}#yiv4752287157 div.yiv4752287157file-title a, #yiv4752287157 div.yiv4752287157file-title a:active, #yiv4752287157 div.yiv4752287157file-title a:hover, #yiv4752287157 div.yiv4752287157file-title a:visited {text-decoration:none;}#yiv4752287157 div.yiv4752287157photo-title a, #yiv4752287157 div.yiv4752287157photo-title a:active, #yiv4752287157 div.yiv4752287157photo-title a:hover, #yiv4752287157 div.yiv4752287157photo-title a:visited {text-decoration:none;}#yiv4752287157 div#yiv4752287157ygrp-mlmsg #yiv4752287157ygrp-msg p a span.yiv4752287157yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4752287157 .yiv4752287157green {color:#628c2a;}#yiv4752287157 .yiv4752287157MsoNormal {margin:0 0 0 0;}#yiv4752287157 o {font-size:0;}#yiv4752287157 #yiv4752287157photos div {float:left;width:72px;}#yiv4752287157 #yiv4752287157photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4752287157 #yiv4752287157photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4752287157 #yiv4752287157reco-category {font-size:77%;}#yiv4752287157 #yiv4752287157reco-desc {font-size:77%;}#yiv4752287157 .yiv4752287157replbq {margin:4px;}#yiv4752287157 #yiv4752287157ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4752287157 #yiv4752287157ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4752287157 #yiv4752287157ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4752287157 #yiv4752287157ygrp-mlmsg select, #yiv4752287157 input, #yiv4752287157 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4752287157 #yiv4752287157ygrp-mlmsg pre, #yiv4752287157 code {font:115% monospace;}#yiv4752287157 #yiv4752287157ygrp-mlmsg * {line-height:1.22em;}#yiv4752287157 #yiv4752287157ygrp-mlmsg #yiv4752287157logo {padding-bottom:10px;}#yiv4752287157 #yiv4752287157ygrp-msg p a {font-family:Verdana;}#yiv4752287157 #yiv4752287157ygrp-msg p#yiv4752287157attach-count span {color:#1E66AE;font-weight:700;}#yiv4752287157 #yiv4752287157ygrp-reco #yiv4752287157reco-head {color:#ff7900;font-weight:700;}#yiv4752287157 #yiv4752287157ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4752287157 #yiv4752287157ygrp-sponsor #yiv4752287157ov li a {font-size:130%;text-decoration:none;}#yiv4752287157 #yiv4752287157ygrp-sponsor #yiv4752287157ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4752287157 #yiv4752287157ygrp-sponsor #yiv4752287157ov ul {margin:0;padding:0 0 0 8px;}#yiv4752287157 #yiv4752287157ygrp-text {font-family:Georgia;}#yiv4752287157 #yiv4752287157ygrp-text p {margin:0 0 1em 0;}#yiv4752287157 #yiv4752287157ygrp-text tt {font-size:120%;}#yiv4752287157 #yiv4752287157ygrp-vital ul li:last-child {border-right:none !important;}#yiv4752287157