Private Sub Worksheet_Activate()
'====membuka kunci protect=========
Worksheets("isinama").Unprotect "1"
'===menentukan cell yang bisa diedit=========
Range("H4:K53").Locked = False
Range("H3").Select
ActiveWindow.Zoom = 100
ActiveWindow.ScrollColumn = 1
Worksheets("isinama").Protect "1", userinterfaceonly:=True
End Sub
Sabtu, 30 Oktober 2021
Sheet "Isi Nama"
Langganan:
Posting Komentar (Atom)
Menghitung USIA Excel
=BYROW(D2:D100; LAMBDA(tanggal_lahir; IF(tanggal_lahir=""; ""; DATEDIF(tanggal_lahir; TODAY(); "y"...
-
klik di sni
-
?worksheets.count 5 ======================== selection.offset (15,0).select ======================= selection.copy selection.offset (2,0)...
-
Option Explicit Sub cetaktabungansetoran() Dim rujukan As Range Dim b As Long Set rujukan = Sheets("CETAKTABUNGAN").Range(...
Tidak ada komentar:
Posting Komentar