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;}-->
