[belajar-excel] Sheet di protect macro tidak jalan

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Sheet di protect macro tidak jalan

Milis Belajar Excel mailing list
Mohon bantuan para master
Ketika sheet di protect menggunakan review==>>protect sheet macro yg semula
jalan jadi tidak jalan.mohon solusinya
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Sheet di protect macro tidak jalan

Milis Belajar Excel mailing list
Agar tetap berjalan, Sheet (Range) yang diedit harus dalam keadaan Unprotect.
Jika Sheet mau tetap diprotect tetapi macro bisa dijalankan maka sebelum Sheet diprotect--> bagian (Range) yang mau diedit harus diUnlocked dulu dengan jalan...Klik kanan Format Cell lalu klik Protection dan cabut centang pada kotak "Locked".
Salam,HK

      From: "farud oke [hidden email] [belajar-excel]" <[hidden email]>
 To: [hidden email]
 Sent: Tuesday, 25 April 2017, 11:30
 Subject: [belajar-excel] Sheet di protect macro tidak jalan
   
    Mohon bantuan para master
Ketika sheet di protect menggunakan review==>>protect sheet macro yg semula jalan jadi tidak jalan.mohon solusinya  #yiv5541600276 #yiv5541600276 -- #yiv5541600276ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5541600276 #yiv5541600276ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5541600276 #yiv5541600276ygrp-mkp #yiv5541600276hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5541600276 #yiv5541600276ygrp-mkp #yiv5541600276ads {margin-bottom:10px;}#yiv5541600276 #yiv5541600276ygrp-mkp .yiv5541600276ad {padding:0 0;}#yiv5541600276 #yiv5541600276ygrp-mkp .yiv5541600276ad p {margin:0;}#yiv5541600276 #yiv5541600276ygrp-mkp .yiv5541600276ad a {color:#0000ff;text-decoration:none;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ygrp-lc {font-family:Arial;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ygrp-lc #yiv5541600276hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ygrp-lc .yiv5541600276ad {margin-bottom:10px;padding:0 0;}#yiv5541600276 #yiv5541600276actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5541600276 #yiv5541600276activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5541600276 #yiv5541600276activity span {font-weight:700;}#yiv5541600276 #yiv5541600276activity span:first-child {text-transform:uppercase;}#yiv5541600276 #yiv5541600276activity span a {color:#5085b6;text-decoration:none;}#yiv5541600276 #yiv5541600276activity span span {color:#ff7900;}#yiv5541600276 #yiv5541600276activity span .yiv5541600276underline {text-decoration:underline;}#yiv5541600276 .yiv5541600276attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5541600276 .yiv5541600276attach div a {text-decoration:none;}#yiv5541600276 .yiv5541600276attach img {border:none;padding-right:5px;}#yiv5541600276 .yiv5541600276attach label {display:block;margin-bottom:5px;}#yiv5541600276 .yiv5541600276attach label a {text-decoration:none;}#yiv5541600276 blockquote {margin:0 0 0 4px;}#yiv5541600276 .yiv5541600276bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5541600276 .yiv5541600276bold a {text-decoration:none;}#yiv5541600276 dd.yiv5541600276last p a {font-family:Verdana;font-weight:700;}#yiv5541600276 dd.yiv5541600276last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5541600276 dd.yiv5541600276last p span.yiv5541600276yshortcuts {margin-right:0;}#yiv5541600276 div.yiv5541600276attach-table div div a {text-decoration:none;}#yiv5541600276 div.yiv5541600276attach-table {width:400px;}#yiv5541600276 div.yiv5541600276file-title a, #yiv5541600276 div.yiv5541600276file-title a:active, #yiv5541600276 div.yiv5541600276file-title a:hover, #yiv5541600276 div.yiv5541600276file-title a:visited {text-decoration:none;}#yiv5541600276 div.yiv5541600276photo-title a, #yiv5541600276 div.yiv5541600276photo-title a:active, #yiv5541600276 div.yiv5541600276photo-title a:hover, #yiv5541600276 div.yiv5541600276photo-title a:visited {text-decoration:none;}#yiv5541600276 div#yiv5541600276ygrp-mlmsg #yiv5541600276ygrp-msg p a span.yiv5541600276yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5541600276 .yiv5541600276green {color:#628c2a;}#yiv5541600276 .yiv5541600276MsoNormal {margin:0 0 0 0;}#yiv5541600276 o {font-size:0;}#yiv5541600276 #yiv5541600276photos div {float:left;width:72px;}#yiv5541600276 #yiv5541600276photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5541600276 #yiv5541600276photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5541600276 #yiv5541600276reco-category {font-size:77%;}#yiv5541600276 #yiv5541600276reco-desc {font-size:77%;}#yiv5541600276 .yiv5541600276replbq {margin:4px;}#yiv5541600276 #yiv5541600276ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5541600276 #yiv5541600276ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5541600276 #yiv5541600276ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5541600276 #yiv5541600276ygrp-mlmsg select, #yiv5541600276 input, #yiv5541600276 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5541600276 #yiv5541600276ygrp-mlmsg pre, #yiv5541600276 code {font:115% monospace;}#yiv5541600276 #yiv5541600276ygrp-mlmsg * {line-height:1.22em;}#yiv5541600276 #yiv5541600276ygrp-mlmsg #yiv5541600276logo {padding-bottom:10px;}#yiv5541600276 #yiv5541600276ygrp-msg p a {font-family:Verdana;}#yiv5541600276 #yiv5541600276ygrp-msg p#yiv5541600276attach-count span {color:#1E66AE;font-weight:700;}#yiv5541600276 #yiv5541600276ygrp-reco #yiv5541600276reco-head {color:#ff7900;font-weight:700;}#yiv5541600276 #yiv5541600276ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ov li a {font-size:130%;text-decoration:none;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ov ul {margin:0;padding:0 0 0 8px;}#yiv5541600276 #yiv5541600276ygrp-text {font-family:Georgia;}#yiv5541600276 #yiv5541600276ygrp-text p {margin:0 0 1em 0;}#yiv5541600276 #yiv5541600276ygrp-text tt {font-size:120%;}#yiv5541600276 #yiv5541600276ygrp-vital ul li:last-child {border-right:none !important;}#yiv5541600276

   
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Sheet di protect macro tidak jalan

Milis Belajar Excel mailing list
Mungkin di dalam process macronya ditambahkan protect dan unprotect sheet

Terima Kasih

Matzen

From: [hidden email] [mailto:[hidden email]]
Sent: 25 April 2017 12:09
To: [hidden email]
Subject: Re: [belajar-excel] Sheet di protect macro tidak jalan


Agar tetap berjalan, Sheet (Range) yang diedit harus dalam keadaan Unprotect.

Jika Sheet mau tetap diprotect tetapi macro bisa dijalankan maka sebelum Sheet diprotect--> bagian (Range) yang mau diedit harus diUnlocked dulu dengan jalan...
Klik kanan Format Cell lalu klik Protection dan cabut centang pada kotak "Locked".

Salam,
HK
________________________________
From: "farud oke [hidden email]<mailto:[hidden email]> [belajar-excel]" <[hidden email]<mailto:[hidden email]>>
To: [hidden email]<mailto:[hidden email]>
Sent: Tuesday, 25 April 2017, 11:30
Subject: [belajar-excel] Sheet di protect macro tidak jalan


Mohon bantuan para master
Ketika sheet di protect menggunakan review==>>protect sheet macro yg semula jalan jadi tidak jalan.mohon solusinya



____________________________________________________________________________
This email has been scanned by AkzoNobel for Viruses and Spam.
For more information please contact your local IT Service Desk.
____________________________________________________________________________
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Sheet di protect macro tidak jalan

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Jika diprotect menggunakan userinterfaceonly = true,

maka macro masih jalan walaupun sheet terproteksi



On 25/04/17 06.02, farud oke [hidden email] [belajar-excel] wrote:
>
> Mohon bantuan para master
> Ketika sheet di protect menggunakan review==>>protect sheet macro yg
> semula jalan jadi tidak jalan.mohon solusinya
>
>

Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Sheet di protect macro tidak jalan

Milis Belajar Excel mailing list
Ditempatkan dmna? workbook ato d module mas..
Bsa dkasih script lgkapny..


Pada tanggal 25 Apr 2017 2.02 PM, "nangagus [hidden email]
[belajar-excel]" <[hidden email]> menulis:


>
>
> Jika diprotect menggunakan userinterfaceonly = true,
>
> maka macro masih jalan walaupun sheet terproteksi
>
>
>
> On 25/04/17 06.02, farud oke [hidden email] [belajar-excel] wrote:
>
>
>
> Mohon bantuan para master
> Ketika sheet di protect menggunakan review==>>protect sheet macro yg
> semula jalan jadi tidak jalan.mohon solusinya
>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Sheet di protect macro tidak jalan [1 Attachment]

Milis Belajar Excel mailing list
Tergantung kebutuhab kalau saya pilih di workbook open:

Private Sub Workbook_Open()
Dim w As Worksheet
For Each w In Worksheets
w.Protect "password", , , , True
Next w
End Sub

Coba lihat contoh lampiran!


On 25/04/17 14.04, farud oke [hidden email] [belajar-excel] wrote:

>
> Ditempatkan dmna? workbook ato d module mas..
> Bsa dkasih script lgkapny..
>
>
> Pada tanggal 25 Apr 2017 2.02 PM, "nangagus [hidden email]
> <mailto:[hidden email]> [belajar-excel]"
> <[hidden email] <mailto:[hidden email]>>
> menulis:
>
>     Jika diprotect menggunakan userinterfaceonly = true,
>
>     maka macro masih jalan walaupun sheet terproteksi
>
>
>
>     On 25/04/17 06.02, farud oke [hidden email]
>     <mailto:[hidden email]> [belajar-excel] wrote:
>>
>>     Mohon bantuan para master
>>     Ketika sheet di protect menggunakan review==>>protect sheet macro
>>     yg semula jalan jadi tidak jalan.mohon solusinya
>>
>
>


Protect sheet.xlsm (26K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Sheet di protect macro tidak jalan

Milis Belajar Excel mailing list
Terima kasih responnya mas..
Itu otomatis sheet terprotek semua ya mas agus,klo seandainya ada 5 sheet
tpi yg mo di protect cma sheet 1 dan sheet 3 saja gmna mas..


Pada tanggal 27 Apr 2017 1.10 PM, "nangagus [hidden email]
[belajar-excel]" <[hidden email]> menulis:


>
>
> Tergantung kebutuhab kalau saya pilih di workbook open:
>
> Private Sub Workbook_Open()
> Dim w As Worksheet
> For Each w In Worksheets
> w.Protect "password", , , , True
> Next w
> End Sub
>
> Coba lihat contoh lampiran!
>
> On 25/04/17 14.04, farud oke [hidden email] [belajar-excel] wrote:
>
>
>
> Ditempatkan dmna? workbook ato d module mas..
> Bsa dkasih script lgkapny..
>
> Pada tanggal 25 Apr 2017 2.02 PM, "nangagus [hidden email]
> [belajar-excel]" <[hidden email]> menulis:
>
>>
>>
>> Jika diprotect menggunakan userinterfaceonly = true,
>>
>> maka macro masih jalan walaupun sheet terproteksi
>>
>>
>>
>> On 25/04/17 06.02, farud oke [hidden email] [belajar-excel] wrote:
>>
>>
>>
>> Mohon bantuan para master
>> Ketika sheet di protect menggunakan review==>>protect sheet macro yg
>> semula jalan jadi tidak jalan.mohon solusinya
>>
>>
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Sheet di protect macro tidak jalan

Milis Belajar Excel mailing list
Private Sub Workbook_Open()
Dim w As Worksheet
For Each w In Worksheets
w.Protect "password", , , , True
Next w
End Sub

diubah menjadi:

Private Sub Workbook_Open()
Sheet1.Protect "password", , , , True
Sheet3.Protect "password", , , , True
End Sub

Perlu diperhatikan Sheet1 dan Sheet2 adalah nama pada excel bukan nama
sheet yang terlihat pada tab sheet.
On 27/04/17 16.11, farud oke [hidden email] [belajar-excel] wrote:

>
> Terima kasih responnya mas..
> Itu otomatis sheet terprotek semua ya mas agus,klo seandainya ada 5
> sheet tpi yg mo di protect cma sheet 1 dan sheet 3 saja gmna mas..
>
>
> Pada tanggal 27 Apr 2017 1.10 PM, "nangagus [hidden email]
> <mailto:[hidden email]> [belajar-excel]"
> <[hidden email] <mailto:[hidden email]>>
> menulis:
>
>     Tergantung kebutuhab kalau saya pilih di workbook open:
>
>     Private Sub Workbook_Open()
>     Dim w As Worksheet
>     For Each w In Worksheets
>     w.Protect "password", , , , True
>     Next w
>     End Sub
>
>     Coba lihat contoh lampiran!
>
>
>     On 25/04/17 14.04, farud oke [hidden email]
>     <mailto:[hidden email]> [belajar-excel] wrote:
>>
>>     Ditempatkan dmna? workbook ato d module mas..
>>     Bsa dkasih script lgkapny..
>>
>>
>>     Pada tanggal 25 Apr 2017 2.02 PM, "nangagus [hidden email]
>>     <mailto:[hidden email]> [belajar-excel]"
>>     <[hidden email]
>>     <mailto:[hidden email]>> menulis:
>>
>>         Jika diprotect menggunakan userinterfaceonly = true,
>>
>>         maka macro masih jalan walaupun sheet terproteksi
>>
>>
>>
>>         On 25/04/17 06.02, farud oke [hidden email]
>>         <mailto:[hidden email]> [belajar-excel] wrote:
>>>
>>>         Mohon bantuan para master
>>>         Ketika sheet di protect menggunakan review==>>protect sheet
>>>         macro yg semula jalan jadi tidak jalan.mohon solusinya
>>>
>>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Sheet di protect macro tidak jalan

Milis Belajar Excel mailing list
Terima kasih mas agus..semuanya berjalan lancar.
Smoga sukses selalu


Pada tanggal 29 Apr 2017 6.37 AM, "nangagus [hidden email]
[belajar-excel]" <[hidden email]> menulis:


>
>
> Private Sub Workbook_Open()

> Dim w As Worksheet
> For Each w In Worksheets
> w.Protect "password", , , , True
> Next w
> End Sub
>
> diubah menjadi:
>
> Private Sub Workbook_Open()
> Sheet1.Protect "password", , , , True
> Sheet3.Protect "password", , , , True
> End Sub
> Perlu diperhatikan Sheet1 dan Sheet2 adalah nama pada excel bukan nama
> sheet yang terlihat pada tab sheet.
> On 27/04/17 16.11, farud oke [hidden email] [belajar-excel] wrote:
>
>
>
> Terima kasih responnya mas..
> Itu otomatis sheet terprotek semua ya mas agus,klo seandainya ada 5 sheet
> tpi yg mo di protect cma sheet 1 dan sheet 3 saja gmna mas..
>
> Pada tanggal 27 Apr 2017 1.10 PM, "nangagus [hidden email]
> [belajar-excel]" <[hidden email]> menulis:
>
>>
>>
>> Tergantung kebutuhab kalau saya pilih di workbook open:
>>
>> Private Sub Workbook_Open()
>> Dim w As Worksheet
>> For Each w In Worksheets
>> w.Protect "password", , , , True
>> Next w
>> End Sub
>>
>> Coba lihat contoh lampiran!
>>
>> On 25/04/17 14.04, farud oke [hidden email] [belajar-excel] wrote:
>>
>>
>>
>> Ditempatkan dmna? workbook ato d module mas..
>> Bsa dkasih script lgkapny..
>>
>> Pada tanggal 25 Apr 2017 2.02 PM, "nangagus [hidden email]
>> [belajar-excel]" <[hidden email]> menulis:
>>
>>>
>>>
>>> Jika diprotect menggunakan userinterfaceonly = true,
>>>
>>> maka macro masih jalan walaupun sheet terproteksi
>>>
>>>
>>>
>>> On 25/04/17 06.02, farud oke [hidden email] [belajar-excel] wrote:
>>>
>>>
>>>
>>> Mohon bantuan para master
>>> Ketika sheet di protect menggunakan review==>>protect sheet macro yg
>>> semula jalan jadi tidak jalan.mohon solusinya
>>>
>>>
>>>
>>
>
>