hehehehhehe...terima kasih master....tapi saya sudah menukan jawabannya, ternyata harus insert mondul dulu ..baru bisa di protek hehhehehehehe....terima kasih sarannya ^,^ Salam Shenly ^^*
Pada Senin, 24 November 2014 10:38, "Hendrik Karnadi hendrikkarn...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Jika disave dgn extension.xlsx...maka file bisa dibuka tapi macronya tidak ada,sedangkan jika disave dgn extension.xlsm atau xlsb maka file bisa dibuka namun makronya tersembunyi dan hanya dibuka dgn password. Sakam,HK Sent from Samsung Mobile -------- Original message --------From: "Nang Agus nanga...@gmail.com [belajar-excel]" Date:24/11/2014 09:23 (GMT+07:00) To: BExcel Subject: Re: [belajar-excel] Tidak bisa Protek macro...????? Dear Shenly, Saya coba dengan file kosong dan macro kosong juga masih bisa jalan, Kemungkinan tidak bisa karena salah penyimpanannya, Coba simpan dalam file "Excel Macro enable" (save as .xlsm) atau simpan dalam file "Excel binary" (save as .xlsb) salam NangAgus 2014-11-23 15:51 GMT+07:00 Shenly shenly_excelma...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>: Halo master, mau tanya..ni saya mau protek macro biar ga bisa di buka..ko gagal terusa yasaya sudah mengikuti caranya dari goole, yaitu, klik kanan di project macronya lalu VBA project properties, lalu ke bagian protek, ceklist lock projet, masukn pass dan cofrin pass, seteleh itu close macro, save filesetelah saya tutup file itu dan saya buka kembali, sya coba buka macro, kok masih bisa di buka yah?????? aneh bgt apa ada yg salah dengan cara-cara saya tadi???memang sih itu filnya kosong, dan blm ada coding macronya...tapi kan harusnya berfungsi juga... tolong solusinya master.....terima kasih Salam Shenly ^^* <!--#yiv9070418226 #yiv9070418226ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9070418226 #yiv9070418226ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9070418226 #yiv9070418226ygrp-mkp #yiv9070418226hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9070418226 #yiv9070418226ygrp-mkp #yiv9070418226ads {margin-bottom:10px;}#yiv9070418226 #yiv9070418226ygrp-mkp .yiv9070418226ad {padding:0 0;}#yiv9070418226 #yiv9070418226ygrp-mkp .yiv9070418226ad p {margin:0;}#yiv9070418226 #yiv9070418226ygrp-mkp .yiv9070418226ad a {color:#0000ff;text-decoration:none;}#yiv9070418226 #yiv9070418226ygrp-sponsor #yiv9070418226ygrp-lc {font-family:Arial;}#yiv9070418226 #yiv9070418226ygrp-sponsor #yiv9070418226ygrp-lc #yiv9070418226hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9070418226 #yiv9070418226ygrp-sponsor #yiv9070418226ygrp-lc .yiv9070418226ad {margin-bottom:10px;padding:0 0;}#yiv9070418226 #yiv9070418226actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9070418226 #yiv9070418226activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9070418226 #yiv9070418226activity span {font-weight:700;}#yiv9070418226 #yiv9070418226activity span:first-child {text-transform:uppercase;}#yiv9070418226 #yiv9070418226activity span a {color:#5085b6;text-decoration:none;}#yiv9070418226 #yiv9070418226activity span span {color:#ff7900;}#yiv9070418226 #yiv9070418226activity span .yiv9070418226underline {text-decoration:underline;}#yiv9070418226 .yiv9070418226attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9070418226 .yiv9070418226attach div a {text-decoration:none;}#yiv9070418226 .yiv9070418226attach img {border:none;padding-right:5px;}#yiv9070418226 .yiv9070418226attach label {display:block;margin-bottom:5px;}#yiv9070418226 .yiv9070418226attach label a {text-decoration:none;}#yiv9070418226 blockquote {margin:0 0 0 4px;}#yiv9070418226 .yiv9070418226bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9070418226 .yiv9070418226bold a {text-decoration:none;}#yiv9070418226 dd.yiv9070418226last p a {font-family:Verdana;font-weight:700;}#yiv9070418226 dd.yiv9070418226last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9070418226 dd.yiv9070418226last p span.yiv9070418226yshortcuts {margin-right:0;}#yiv9070418226 div.yiv9070418226attach-table div div a {text-decoration:none;}#yiv9070418226 div.yiv9070418226attach-table {width:400px;}#yiv9070418226 div.yiv9070418226file-title a, #yiv9070418226 div.yiv9070418226file-title a:active, #yiv9070418226 div.yiv9070418226file-title a:hover, #yiv9070418226 div.yiv9070418226file-title a:visited {text-decoration:none;}#yiv9070418226 div.yiv9070418226photo-title a, #yiv9070418226 div.yiv9070418226photo-title a:active, #yiv9070418226 div.yiv9070418226photo-title a:hover, #yiv9070418226 div.yiv9070418226photo-title a:visited {text-decoration:none;}#yiv9070418226 div#yiv9070418226ygrp-mlmsg #yiv9070418226ygrp-msg p a span.yiv9070418226yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9070418226 .yiv9070418226green {color:#628c2a;}#yiv9070418226 .yiv9070418226MsoNormal {margin:0 0 0 0;}#yiv9070418226 o {font-size:0;}#yiv9070418226 #yiv9070418226photos div {float:left;width:72px;}#yiv9070418226 #yiv9070418226photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9070418226 #yiv9070418226photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9070418226 #yiv9070418226reco-category {font-size:77%;}#yiv9070418226 #yiv9070418226reco-desc {font-size:77%;}#yiv9070418226 .yiv9070418226replbq {margin:4px;}#yiv9070418226 #yiv9070418226ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9070418226 #yiv9070418226ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9070418226 #yiv9070418226ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9070418226 #yiv9070418226ygrp-mlmsg select, #yiv9070418226 input, #yiv9070418226 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9070418226 #yiv9070418226ygrp-mlmsg pre, #yiv9070418226 code {font:115% monospace;}#yiv9070418226 #yiv9070418226ygrp-mlmsg * {line-height:1.22em;}#yiv9070418226 #yiv9070418226ygrp-mlmsg #yiv9070418226logo {padding-bottom:10px;}#yiv9070418226 #yiv9070418226ygrp-msg p a {font-family:Verdana;}#yiv9070418226 #yiv9070418226ygrp-msg p#yiv9070418226attach-count span {color:#1E66AE;font-weight:700;}#yiv9070418226 #yiv9070418226ygrp-reco #yiv9070418226reco-head {color:#ff7900;font-weight:700;}#yiv9070418226 #yiv9070418226ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9070418226 #yiv9070418226ygrp-sponsor #yiv9070418226ov li a {font-size:130%;text-decoration:none;}#yiv9070418226 #yiv9070418226ygrp-sponsor #yiv9070418226ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9070418226 #yiv9070418226ygrp-sponsor #yiv9070418226ov ul {margin:0;padding:0 0 0 8px;}#yiv9070418226 #yiv9070418226ygrp-text {font-family:Georgia;}#yiv9070418226 #yiv9070418226ygrp-text p {margin:0 0 1em 0;}#yiv9070418226 #yiv9070418226ygrp-text tt {font-size:120%;}#yiv9070418226 #yiv9070418226ygrp-vital ul li:last-child {border-right:none !important;}-->