Kamis, 27 November 2014

[belajar-excel] Digest Number 3204

4 Messages

Digest #3204
1a
Fw: [belajar-excel] cari data sama [1 Attachment] by "hendrik karnadi" hendrikkarnadi
2a
Re: Password protect sheet by "hendrik karnadi" hendrikkarnadi
2c
Re: Bls: Re: [belajar-excel] Password protect sheet by "Hendrik Karnadi" hendrikkarnadi

Messages

Thu Nov 27, 2014 1:16 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Fathir,Coba juga pake macro ini yang memanfaatkan Worksheet Event (Worksheet_BeforeDoubleClick).Jangan lupa aktifkan macronya.Nama lampiran filenya HK_Cari Saldo.xlsm
Salam,HK
----- Forwarded Message -----
From: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: BeExcel <belajar-excel@yahoogroups.com>
Sent: Thursday, 27 November 2014, 8:27
Subject: Re: [belajar-excel] cari data sama [1 Attachment]

  Wa'alaikumussalam wr wb

Hai Fathir,

File terlampir memanfaatkan fitur Excel Table agar rujukan formula bisa dinamis diatur oleh si Excel alias tidak perlu capek-capek mengubah rujukan formula ketika datanya bertambah.

Conditional formatting digunakan untuk memberi tanda. Conditional formatting bisa dibuat melalui :
     ribbon Home -> group Styles -> Conditional Formatting -> New Rule

Wassalamu'alaikum wr wb
Kid.

2014-11-27 3:56 GMT+11:00 fathir ali payripayali@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  assalamualaikum wrb dear master excel mohon pencerahannnya sy ada data tagihan dan data yg sudah di bayar yg jumlahnya ribuan . sy kesulitan untuk mencocokan data yg sudah di bayarkan di data tagihan selama ini sy menggunakan control find  adakah cara yg lebih cepat selain  itu menggigat datanya ribuan. berikut file dummy sy lampirkan
atas bantuannya sy ucapkan terima kasih

#yiv7919157115 #yiv7919157115 -- #yiv7919157115ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7919157115 #yiv7919157115ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7919157115 #yiv7919157115ygrp-mkp #yiv7919157115hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7919157115 #yiv7919157115ygrp-mkp #yiv7919157115ads {margin-bottom:10px;}#yiv7919157115 #yiv7919157115ygrp-mkp .yiv7919157115ad {padding:0 0;}#yiv7919157115 #yiv7919157115ygrp-mkp .yiv7919157115ad p {margin:0;}#yiv7919157115 #yiv7919157115ygrp-mkp .yiv7919157115ad a {color:#0000ff;text-decoration:none;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ygrp-lc {font-family:Arial;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ygrp-lc #yiv7919157115hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ygrp-lc .yiv7919157115ad {margin-bottom:10px;padding:0 0;}#yiv7919157115 #yiv7919157115actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7919157115 #yiv7919157115activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7919157115 #yiv7919157115activity span {font-weight:700;}#yiv7919157115 #yiv7919157115activity span:first-child {text-transform:uppercase;}#yiv7919157115 #yiv7919157115activity span a {color:#5085b6;text-decoration:none;}#yiv7919157115 #yiv7919157115activity span span {color:#ff7900;}#yiv7919157115 #yiv7919157115activity span .yiv7919157115underline {text-decoration:underline;}#yiv7919157115 .yiv7919157115attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7919157115 .yiv7919157115attach div a {text-decoration:none;}#yiv7919157115 .yiv7919157115attach img {border:none;padding-right:5px;}#yiv7919157115 .yiv7919157115attach label {display:block;margin-bottom:5px;}#yiv7919157115 .yiv7919157115attach label a {text-decoration:none;}#yiv7919157115 blockquote {margin:0 0 0 4px;}#yiv7919157115 .yiv7919157115bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7919157115 .yiv7919157115bold a {text-decoration:none;}#yiv7919157115 dd.yiv7919157115last p a {font-family:Verdana;font-weight:700;}#yiv7919157115 dd.yiv7919157115last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7919157115 dd.yiv7919157115last p span.yiv7919157115yshortcuts {margin-right:0;}#yiv7919157115 div.yiv7919157115attach-table div div a {text-decoration:none;}#yiv7919157115 div.yiv7919157115attach-table {width:400px;}#yiv7919157115 div.yiv7919157115file-title a, #yiv7919157115 div.yiv7919157115file-title a:active, #yiv7919157115 div.yiv7919157115file-title a:hover, #yiv7919157115 div.yiv7919157115file-title a:visited {text-decoration:none;}#yiv7919157115 div.yiv7919157115photo-title a, #yiv7919157115 div.yiv7919157115photo-title a:active, #yiv7919157115 div.yiv7919157115photo-title a:hover, #yiv7919157115 div.yiv7919157115photo-title a:visited {text-decoration:none;}#yiv7919157115 div#yiv7919157115ygrp-mlmsg #yiv7919157115ygrp-msg p a span.yiv7919157115yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7919157115 .yiv7919157115green {color:#628c2a;}#yiv7919157115 .yiv7919157115MsoNormal {margin:0 0 0 0;}#yiv7919157115 o {font-size:0;}#yiv7919157115 #yiv7919157115photos div {float:left;width:72px;}#yiv7919157115 #yiv7919157115photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7919157115 #yiv7919157115photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7919157115 #yiv7919157115reco-category {font-size:77%;}#yiv7919157115 #yiv7919157115reco-desc {font-size:77%;}#yiv7919157115 .yiv7919157115replbq {margin:4px;}#yiv7919157115 #yiv7919157115ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7919157115 #yiv7919157115ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7919157115 #yiv7919157115ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7919157115 #yiv7919157115ygrp-mlmsg select, #yiv7919157115 input, #yiv7919157115 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7919157115 #yiv7919157115ygrp-mlmsg pre, #yiv7919157115 code {font:115% monospace;}#yiv7919157115 #yiv7919157115ygrp-mlmsg * {line-height:1.22em;}#yiv7919157115 #yiv7919157115ygrp-mlmsg #yiv7919157115logo {padding-bottom:10px;}#yiv7919157115 #yiv7919157115ygrp-msg p a {font-family:Verdana;}#yiv7919157115 #yiv7919157115ygrp-msg p#yiv7919157115attach-count span {color:#1E66AE;font-weight:700;}#yiv7919157115 #yiv7919157115ygrp-reco #yiv7919157115reco-head {color:#ff7900;font-weight:700;}#yiv7919157115 #yiv7919157115ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ov li a {font-size:130%;text-decoration:none;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ov ul {margin:0;padding:0 0 0 8px;}#yiv7919157115 #yiv7919157115ygrp-text {font-family:Georgia;}#yiv7919157115 #yiv7919157115ygrp-text p {margin:0 0 1em 0;}#yiv7919157115 #yiv7919157115ygrp-text tt {font-size:120%;}#yiv7919157115 #yiv7919157115ygrp-vital ul li:last-child {border-right:none !important;}#yiv7919157115

Thu Nov 27, 2014 1:36 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Tiny,Untuk mempassword VB...Tekan Alt F11 untuk masuk ke VBE SheetKlik Tools, VBAProject Properties, Protection....Centang Lock project for viewing dan masukkan serta confirm PWD (jangan lupa PWD nya).
Salam,,HK

From: "hartini dewi hartini_80@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Thursday, 27 November 2014, 12:47
Subject: [belajar-excel] Password protect sheet

 
| Dear all,
Saya melakukan hidden sheet menggunakan vb dengan mengganti visible menjadi veryhidden, bagaimn agar vb tsb bisa di password sehingga sheet yg saya hidden tdk bisa ditampilkan kecuali saya yg membukanya.
Mohon pencerahannya
Terima kasih
Salam
Tiny |

<!--#yiv1728817097 #yiv1728817097ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1728817097 #yiv1728817097ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1728817097 #yiv1728817097ygrp-mkp #yiv1728817097hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1728817097 #yiv1728817097ygrp-mkp #yiv1728817097ads {margin-bottom:10px;}#yiv1728817097 #yiv1728817097ygrp-mkp .yiv1728817097ad {padding:0 0;}#yiv1728817097 #yiv1728817097ygrp-mkp .yiv1728817097ad p {margin:0;}#yiv1728817097 #yiv1728817097ygrp-mkp .yiv1728817097ad a {color:#0000ff;text-decoration:none;}#yiv1728817097 #yiv1728817097ygrp-sponsor #yiv1728817097ygrp-lc {font-family:Arial;}#yiv1728817097 #yiv1728817097ygrp-sponsor #yiv1728817097ygrp-lc #yiv1728817097hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1728817097 #yiv1728817097ygrp-sponsor #yiv1728817097ygrp-lc .yiv1728817097ad {margin-bottom:10px;padding:0 0;}#yiv1728817097 #yiv1728817097actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1728817097 #yiv1728817097activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1728817097 #yiv1728817097activity span {font-weight:700;}#yiv1728817097 #yiv1728817097activity span:first-child {text-transform:uppercase;}#yiv1728817097 #yiv1728817097activity span a {color:#5085b6;text-decoration:none;}#yiv1728817097 #yiv1728817097activity span span {color:#ff7900;}#yiv1728817097 #yiv1728817097activity span .yiv1728817097underline {text-decoration:underline;}#yiv1728817097 .yiv1728817097attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1728817097 .yiv1728817097attach div a {text-decoration:none;}#yiv1728817097 .yiv1728817097attach img {border:none;padding-right:5px;}#yiv1728817097 .yiv1728817097attach label {display:block;margin-bottom:5px;}#yiv1728817097 .yiv1728817097attach label a {text-decoration:none;}#yiv1728817097 blockquote {margin:0 0 0 4px;}#yiv1728817097 .yiv1728817097bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1728817097 .yiv1728817097bold a {text-decoration:none;}#yiv1728817097 dd.yiv1728817097last p a {font-family:Verdana;font-weight:700;}#yiv1728817097 dd.yiv1728817097last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1728817097 dd.yiv1728817097last p span.yiv1728817097yshortcuts {margin-right:0;}#yiv1728817097 div.yiv1728817097attach-table div div a {text-decoration:none;}#yiv1728817097 div.yiv1728817097attach-table {width:400px;}#yiv1728817097 div.yiv1728817097file-title a, #yiv1728817097 div.yiv1728817097file-title a:active, #yiv1728817097 div.yiv1728817097file-title a:hover, #yiv1728817097 div.yiv1728817097file-title a:visited {text-decoration:none;}#yiv1728817097 div.yiv1728817097photo-title a, #yiv1728817097 div.yiv1728817097photo-title a:active, #yiv1728817097 div.yiv1728817097photo-title a:hover, #yiv1728817097 div.yiv1728817097photo-title a:visited {text-decoration:none;}#yiv1728817097 div#yiv1728817097ygrp-mlmsg #yiv1728817097ygrp-msg p a span.yiv1728817097yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1728817097 .yiv1728817097green {color:#628c2a;}#yiv1728817097 .yiv1728817097MsoNormal {margin:0 0 0 0;}#yiv1728817097 o {font-size:0;}#yiv1728817097 #yiv1728817097photos div {float:left;width:72px;}#yiv1728817097 #yiv1728817097photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1728817097 #yiv1728817097photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1728817097 #yiv1728817097reco-category {font-size:77%;}#yiv1728817097 #yiv1728817097reco-desc {font-size:77%;}#yiv1728817097 .yiv1728817097replbq {margin:4px;}#yiv1728817097 #yiv1728817097ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1728817097 #yiv1728817097ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1728817097 #yiv1728817097ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1728817097 #yiv1728817097ygrp-mlmsg select, #yiv1728817097 input, #yiv1728817097 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1728817097 #yiv1728817097ygrp-mlmsg pre, #yiv1728817097 code {font:115% monospace;}#yiv1728817097 #yiv1728817097ygrp-mlmsg * {line-height:1.22em;}#yiv1728817097 #yiv1728817097ygrp-mlmsg #yiv1728817097logo {padding-bottom:10px;}#yiv1728817097 #yiv1728817097ygrp-msg p a {font-family:Verdana;}#yiv1728817097 #yiv1728817097ygrp-msg p#yiv1728817097attach-count span {color:#1E66AE;font-weight:700;}#yiv1728817097 #yiv1728817097ygrp-reco #yiv1728817097reco-head {color:#ff7900;font-weight:700;}#yiv1728817097 #yiv1728817097ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1728817097 #yiv1728817097ygrp-sponsor #yiv1728817097ov li a {font-size:130%;text-decoration:none;}#yiv1728817097 #yiv1728817097ygrp-sponsor #yiv1728817097ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1728817097 #yiv1728817097ygrp-sponsor #yiv1728817097ov ul {margin:0;padding:0 0 0 8px;}#yiv1728817097 #yiv1728817097ygrp-text {font-family:Georgia;}#yiv1728817097 #yiv1728817097ygrp-text p {margin:0 0 1em 0;}#yiv1728817097 #yiv1728817097ygrp-text tt {font-size:120%;}#yiv1728817097 #yiv1728817097ygrp-vital ul li:last-child {border-right:none !important;}-->

Thu Nov 27, 2014 2:31 am (PST) . Posted by:

"hartini dewi" hartini_80

Dear pak hendrik,
Td saya sdh coba sprti itu pak, stlh saya save dan buka kembali ternyata msh bisa dibuka.
Salahnya dimn ya kira2
Terima kasih
Salah
Tiny

Dikirim dari Yahoo Mail pada Android

Thu Nov 27, 2014 3:21 am (PST) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Bisa dibuat dan dikirimkan dummy filenya?

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: "hartini dewi hartini_80@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> </div><div>Date:27/11/2014 17:28 (GMT+07:00) </div><div>To: belajar-excel@yahoogroups.com </div><div>Subject: Bls: Re: [belajar-excel] Password protect sheet </div><div>
</div>Dear pak hendrik,
Td saya sdh coba sprti itu pak, stlh saya save dan buka kembali ternyata msh bisa dibuka.
Salahnya dimn ya kira2
Terima kasih
Salah
Tiny

Dikirim dari Yahoo Mail pada Android

Dari:"hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Tanggal:Kam, 27 Nov 2014 pada 17:36
Judul:Re: [belajar-excel] Password protect sheet

Hai Tiny,
Untuk mempassword VB...
Tekan Alt F11 untuk masuk ke VBE Sheet
Klik Tools, VBAProject Properties, Protection....
Centang Lock project for viewing dan masukkan serta confirm PWD (jangan lupa PWD nya).

Salam,,
HK

From: "hartini dewi hartini_80@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Thursday, 27 November 2014, 12:47
Subject: [belajar-excel] Password protect sheet

Dear all,
Saya melakukan hidden sheet menggunakan vb dengan mengganti visible menjadi veryhidden, bagaimn agar vb tsb bisa di password sehingga sheet yg saya hidden tdk bisa ditampilkan kecuali saya yg membukanya.
Mohon pencerahannya
Terima kasih
Salam
Tiny

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com

berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar