Mas Agus,Saya blm pernah meng-encripsi dan membukanya...boleh tahu 
codenya...Terima kasih.
Salam,HK

    ----- Forwarded Message -----
  From: "Nang Agus [email protected] [belajar-excel]" 
<[email protected]>
 To: BExcel <[email protected]> 
 Sent: Friday, 2 January 2015, 9:11
 Subject: Re: [belajar-excel] Form Login [1 Attachment]
   
    Dear Jack

ada form login dengan dasar cekrip warisan dari mbah siti dengan editan 
disana-sini
ada 2 user yang tertanam di sheet "Jeneng" :
admin  admin
nang   agus
untuk user admin dapat menambah user baru tapi cekrip untuk menghapus user 
belum sempat membuat. (user yang lain tidak dapat menambah user.)
user dan password dienkripsi dua kali dengan rumus yang sangat sederhana 
sehingga mudah untuk di deskrip kembali.
silahkan dioprek sesuai kebutuhan, jika masih banyak cekrip yang salah 
diposting lagi aja di milis biar banyak yang membantu
salam
NangAgus

2014-12-29 14:27 GMT+07:00 Jack Carmelo [email protected] [belajar-excel] 
<[email protected]>:

     
| Dear Master
Mohon bantuannya untuk form login ini
Saya ingin membuat 1 form login untuk beberapa username. Kalau untuk 1 username 
sudah bisa saya buat tapi untuk beberapa username bagamana kodenya? Makasih 
atas bantuannya. Dan pertanyaan lanjutan kalau itu terjawab. Bisakah kita 
mengecek bahwa data yang diinput itu oleh username A atau B dstnya. 
Makasih atas bantuannya. File contoh dengan 1 username terlampir.
Username : admin
Password : admin
Salam
JackDikirim dari Yahoo Mail pada Android |

   

  #yiv9783415631 #yiv9783415631 -- #yiv9783415631ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9783415631 
#yiv9783415631ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9783415631 
#yiv9783415631ygrp-mkp #yiv9783415631hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9783415631 #yiv9783415631ygrp-mkp #yiv9783415631ads 
{margin-bottom:10px;}#yiv9783415631 #yiv9783415631ygrp-mkp .yiv9783415631ad 
{padding:0 0;}#yiv9783415631 #yiv9783415631ygrp-mkp .yiv9783415631ad p 
{margin:0;}#yiv9783415631 #yiv9783415631ygrp-mkp .yiv9783415631ad a 
{color:#0000ff;text-decoration:none;}#yiv9783415631 #yiv9783415631ygrp-sponsor 
#yiv9783415631ygrp-lc {font-family:Arial;}#yiv9783415631 
#yiv9783415631ygrp-sponsor #yiv9783415631ygrp-lc #yiv9783415631hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9783415631 
#yiv9783415631ygrp-sponsor #yiv9783415631ygrp-lc .yiv9783415631ad 
{margin-bottom:10px;padding:0 0;}#yiv9783415631 #yiv9783415631actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9783415631 
#yiv9783415631activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9783415631
 #yiv9783415631activity span {font-weight:700;}#yiv9783415631 
#yiv9783415631activity span:first-child 
{text-transform:uppercase;}#yiv9783415631 #yiv9783415631activity span a 
{color:#5085b6;text-decoration:none;}#yiv9783415631 #yiv9783415631activity span 
span {color:#ff7900;}#yiv9783415631 #yiv9783415631activity span 
.yiv9783415631underline {text-decoration:underline;}#yiv9783415631 
.yiv9783415631attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9783415631 .yiv9783415631attach div a 
{text-decoration:none;}#yiv9783415631 .yiv9783415631attach img 
{border:none;padding-right:5px;}#yiv9783415631 .yiv9783415631attach label 
{display:block;margin-bottom:5px;}#yiv9783415631 .yiv9783415631attach label a 
{text-decoration:none;}#yiv9783415631 blockquote {margin:0 0 0 
4px;}#yiv9783415631 .yiv9783415631bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9783415631 
.yiv9783415631bold a {text-decoration:none;}#yiv9783415631 dd.yiv9783415631last 
p a {font-family:Verdana;font-weight:700;}#yiv9783415631 dd.yiv9783415631last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9783415631 
dd.yiv9783415631last p span.yiv9783415631yshortcuts 
{margin-right:0;}#yiv9783415631 div.yiv9783415631attach-table div div a 
{text-decoration:none;}#yiv9783415631 div.yiv9783415631attach-table 
{width:400px;}#yiv9783415631 div.yiv9783415631file-title a, #yiv9783415631 
div.yiv9783415631file-title a:active, #yiv9783415631 
div.yiv9783415631file-title a:hover, #yiv9783415631 div.yiv9783415631file-title 
a:visited {text-decoration:none;}#yiv9783415631 div.yiv9783415631photo-title a, 
#yiv9783415631 div.yiv9783415631photo-title a:active, #yiv9783415631 
div.yiv9783415631photo-title a:hover, #yiv9783415631 
div.yiv9783415631photo-title a:visited {text-decoration:none;}#yiv9783415631 
div#yiv9783415631ygrp-mlmsg #yiv9783415631ygrp-msg p a 
span.yiv9783415631yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9783415631 
.yiv9783415631green {color:#628c2a;}#yiv9783415631 .yiv9783415631MsoNormal 
{margin:0 0 0 0;}#yiv9783415631 o {font-size:0;}#yiv9783415631 
#yiv9783415631photos div {float:left;width:72px;}#yiv9783415631 
#yiv9783415631photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv9783415631 
#yiv9783415631photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9783415631
 #yiv9783415631reco-category {font-size:77%;}#yiv9783415631 
#yiv9783415631reco-desc {font-size:77%;}#yiv9783415631 .yiv9783415631replbq 
{margin:4px;}#yiv9783415631 #yiv9783415631ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv9783415631 #yiv9783415631ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9783415631 
#yiv9783415631ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9783415631 
#yiv9783415631ygrp-mlmsg select, #yiv9783415631 input, #yiv9783415631 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9783415631 
#yiv9783415631ygrp-mlmsg pre, #yiv9783415631 code {font:115% 
monospace;}#yiv9783415631 #yiv9783415631ygrp-mlmsg * 
{line-height:1.22em;}#yiv9783415631 #yiv9783415631ygrp-mlmsg #yiv9783415631logo 
{padding-bottom:10px;}#yiv9783415631 #yiv9783415631ygrp-msg p a 
{font-family:Verdana;}#yiv9783415631 #yiv9783415631ygrp-msg 
p#yiv9783415631attach-count span {color:#1E66AE;font-weight:700;}#yiv9783415631 
#yiv9783415631ygrp-reco #yiv9783415631reco-head 
{color:#ff7900;font-weight:700;}#yiv9783415631 #yiv9783415631ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv9783415631 #yiv9783415631ygrp-sponsor 
#yiv9783415631ov li a {font-size:130%;text-decoration:none;}#yiv9783415631 
#yiv9783415631ygrp-sponsor #yiv9783415631ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9783415631 
#yiv9783415631ygrp-sponsor #yiv9783415631ov ul {margin:0;padding:0 0 0 
8px;}#yiv9783415631 #yiv9783415631ygrp-text 
{font-family:Georgia;}#yiv9783415631 #yiv9783415631ygrp-text p {margin:0 0 1em 
0;}#yiv9783415631 #yiv9783415631ygrp-text tt {font-size:120%;}#yiv9783415631 
#yiv9783415631ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv9783415631 

  

Attachment: Form Login.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Kirim email ke