sebelum di protect, pasang freeze panes yang diinginkan. Setelah itu barulah sheet di protect.
Regards, Kid On Tue, Nov 24, 2015 at 4:43 PM, marone oke [email protected] [belajar-excel] <[email protected]> wrote: > > > tengkyu mr. kid > > ada lagi nih... > saya mau protect sheet...tapi freeze panes aktif...gimana ya.. > > tks > > > > Pada Selasa, 24 November 2015 6:36, "'Mr. Kid' [email protected] > [belajar-excel]" <[email protected]> menulis: > > > > Hai Marone, > > Manualnya begini : > 1. ribbon Review -> group Changes -> Protect Sheet -> muncul dialog window > protect sheet > 2. isi password (bila perlu) -> centang yang diperbolehkan -> tekan OK > untuk bisa border, berarti format cells yang di centang. Tapi, segala > macam format cells bisa dilakukan. > > Jika ingin tahu kode VBA nya, lakukan cara manual tersebut saat proses > record macro dijalankan, alias lakukan macro recording > > Regards, > Kid > > > > > > On Mon, Nov 23, 2015 at 6:12 PM, marone oke [email protected] > [belajar-excel] <[email protected]> wrote: > > > dear master,, > > tolong code macro, protect sheet tapi borders tetap aktif..... > > tks bantuannya > > > > > >

