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 [email protected] [belajar-excel] wrote:
Ditempatkan dmna? workbook ato d module mas.. Bsa dkasih script lgkapny..Pada tanggal 25 Apr 2017 2.02 PM, "nangagus [email protected] <mailto:[email protected]> [belajar-excel]" <[email protected] <mailto:[email protected]>> menulis:Jika diprotect menggunakan userinterfaceonly = true, maka macro masih jalan walaupun sheet terproteksi On 25/04/17 06.02, farud oke [email protected] <mailto:[email protected]> [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
Description: application/vnd.ms-excel.sheet.macroenabled.12
