hehe...saya salah paham dalam membacanya
terimakasih pak guru... br,
odong nando
Dari: "nangagus [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Senin, 21 Agustus 2017 11:27
Judul: Re: Bls: [belajar-excel] Terbilang Angka ke Huruf (Bahasa Inggris)
tanpa Macro
Dear odong, File tersebut tanpa macro, hanya menggunakan names. Names
disembunyikan, cara menampakkannya sudah disertakan pada email mas Zaenul salam
On 21/08/2017 11:08, odong nando [email protected] [belajar-excel] wrote:
hai mas zainul,
saya itu malah penasaran dengan .xlsx kok bisa menyimpan macro ya...?
mohon sering ilmunya, n klo boleh itu protec macro nya di buka dunk, biar
bisa di aplikasikan di workbook lain...
terimakasih... br,
odong nando
Dari: "[email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Sabtu, 19 Agustus 2017 12:53
Judul: [belajar-excel] Terbilang Angka ke Huruf (Bahasa Inggris) tanpa Macro
[1 Attachment]
Teman2 be-exelers,
Saya iseng membuat fungsi terbilang dari angka ke huruf dalam bahasa inggris
dengan menggunakan "named range". Fungsi tersebut biasanya digunaakan saat
membuat kwitansi atau invoice.
Mohon untuk turut mengujinya barangkali ada yang salah atau ada yang berminat
untuk mengembangkan ke bahasa yang lain.
Jika penasaran ingin melihat rumus dalam "named range", gunakan macro
berikut:
Sub ss()
For Each s In ThisWorkbook.Names
s.Visible = true
Next
End Sub
terimakasih, -zainul
#yiv3177434149 #yiv3177434149 -- #yiv3177434149ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3177434149
#yiv3177434149ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3177434149
#yiv3177434149ygrp-mkp #yiv3177434149hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3177434149 #yiv3177434149ygrp-mkp #yiv3177434149ads
{margin-bottom:10px;}#yiv3177434149 #yiv3177434149ygrp-mkp .yiv3177434149ad
{padding:0 0;}#yiv3177434149 #yiv3177434149ygrp-mkp .yiv3177434149ad p
{margin:0;}#yiv3177434149 #yiv3177434149ygrp-mkp .yiv3177434149ad a
{color:#0000ff;text-decoration:none;}#yiv3177434149 #yiv3177434149ygrp-sponsor
#yiv3177434149ygrp-lc {font-family:Arial;}#yiv3177434149
#yiv3177434149ygrp-sponsor #yiv3177434149ygrp-lc #yiv3177434149hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3177434149
#yiv3177434149ygrp-sponsor #yiv3177434149ygrp-lc .yiv3177434149ad
{margin-bottom:10px;padding:0 0;}#yiv3177434149 #yiv3177434149actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3177434149
#yiv3177434149activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3177434149
#yiv3177434149activity span {font-weight:700;}#yiv3177434149
#yiv3177434149activity span:first-child
{text-transform:uppercase;}#yiv3177434149 #yiv3177434149activity span a
{color:#5085b6;text-decoration:none;}#yiv3177434149 #yiv3177434149activity span
span {color:#ff7900;}#yiv3177434149 #yiv3177434149activity span
.yiv3177434149underline {text-decoration:underline;}#yiv3177434149
.yiv3177434149attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3177434149 .yiv3177434149attach div a
{text-decoration:none;}#yiv3177434149 .yiv3177434149attach img
{border:none;padding-right:5px;}#yiv3177434149 .yiv3177434149attach label
{display:block;margin-bottom:5px;}#yiv3177434149 .yiv3177434149attach label a
{text-decoration:none;}#yiv3177434149 blockquote {margin:0 0 0
4px;}#yiv3177434149 .yiv3177434149bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3177434149
.yiv3177434149bold a {text-decoration:none;}#yiv3177434149 dd.yiv3177434149last
p a {font-family:Verdana;font-weight:700;}#yiv3177434149 dd.yiv3177434149last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3177434149
dd.yiv3177434149last p span.yiv3177434149yshortcuts
{margin-right:0;}#yiv3177434149 div.yiv3177434149attach-table div div a
{text-decoration:none;}#yiv3177434149 div.yiv3177434149attach-table
{width:400px;}#yiv3177434149 div.yiv3177434149file-title a, #yiv3177434149
div.yiv3177434149file-title a:active, #yiv3177434149
div.yiv3177434149file-title a:hover, #yiv3177434149 div.yiv3177434149file-title
a:visited {text-decoration:none;}#yiv3177434149 div.yiv3177434149photo-title a,
#yiv3177434149 div.yiv3177434149photo-title a:active, #yiv3177434149
div.yiv3177434149photo-title a:hover, #yiv3177434149
div.yiv3177434149photo-title a:visited {text-decoration:none;}#yiv3177434149
div#yiv3177434149ygrp-mlmsg #yiv3177434149ygrp-msg p a
span.yiv3177434149yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3177434149
.yiv3177434149green {color:#628c2a;}#yiv3177434149 .yiv3177434149MsoNormal
{margin:0 0 0 0;}#yiv3177434149 o {font-size:0;}#yiv3177434149
#yiv3177434149photos div {float:left;width:72px;}#yiv3177434149
#yiv3177434149photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3177434149
#yiv3177434149photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3177434149
#yiv3177434149reco-category {font-size:77%;}#yiv3177434149
#yiv3177434149reco-desc {font-size:77%;}#yiv3177434149 .yiv3177434149replbq
{margin:4px;}#yiv3177434149 #yiv3177434149ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3177434149 #yiv3177434149ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3177434149
#yiv3177434149ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3177434149
#yiv3177434149ygrp-mlmsg select, #yiv3177434149 input, #yiv3177434149 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3177434149
#yiv3177434149ygrp-mlmsg pre, #yiv3177434149 code {font:115%
monospace;}#yiv3177434149 #yiv3177434149ygrp-mlmsg *
{line-height:1.22em;}#yiv3177434149 #yiv3177434149ygrp-mlmsg #yiv3177434149logo
{padding-bottom:10px;}#yiv3177434149 #yiv3177434149ygrp-msg p a
{font-family:Verdana;}#yiv3177434149 #yiv3177434149ygrp-msg
p#yiv3177434149attach-count span {color:#1E66AE;font-weight:700;}#yiv3177434149
#yiv3177434149ygrp-reco #yiv3177434149reco-head
{color:#ff7900;font-weight:700;}#yiv3177434149 #yiv3177434149ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3177434149 #yiv3177434149ygrp-sponsor
#yiv3177434149ov li a {font-size:130%;text-decoration:none;}#yiv3177434149
#yiv3177434149ygrp-sponsor #yiv3177434149ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3177434149
#yiv3177434149ygrp-sponsor #yiv3177434149ov ul {margin:0;padding:0 0 0
8px;}#yiv3177434149 #yiv3177434149ygrp-text
{font-family:Georgia;}#yiv3177434149 #yiv3177434149ygrp-text p {margin:0 0 1em
0;}#yiv3177434149 #yiv3177434149ygrp-text tt {font-size:120%;}#yiv3177434149
#yiv3177434149ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3177434149
