Kamis, 18 Juni 2015

[belajar-excel] Digest Number 3478

15 Messages

Digest #3478
1a
Re: Bls: [belajar-excel] hapus kolom kosong by "Hendrik Karnadi" hendrikkarnadi
2a
3a
3b
Delete dan Paste gambar dengan Macro by "Fajar Fatahillah" fajar.fatahillah

Messages

Wed Jun 17, 2015 2:46 am (PDT) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Hai Liem,
Satu record kan terdiri satu baris dan bbrp kolom, jadi kalau ada suatu invoive yang terdiri dari beberapa baris (sub item) tentunya kolom yg ada judulnya tidak boleh kosong...apalagi dihapus.

Mr. Kid mungkin bisa menambahkan coretannya mengenai database yang baik.....yang juga sering dibahas sebelunnya.

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> </div><div>Date:17/06/2015 2:15 PM (GMT+07:00) </div><div>To: belajar-excel@yahoogroups.com </div><div>Subject: Bls: [belajar-excel] hapus kolom kosong </div><div>
</div>pak hk..
sudah saya coba untuk solusi pak hk tp ketika data misal di kolom J datanya kan gak rapat.. jadiny belum sesuai keinginan
maksud saya kolom yang gak ada headernya yng gak di hapus pak..

salam
liem

Pada Rabu, 17 Juni 2015 13:59, "Hendrik Karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Hai Liem,
Coba lakukan langkag berikut ini:
- blok datanya dari kolom awal smp akhir
- Tekan tombol F5 lalu pilih blanks
- Tekan tombol del.

Salam,
HK

Sent from Samsung Mobile

-------- Original message --------
From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]"
Date:17/06/2015 12:08 PM (GMT+07:00)
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] hapus kolom kosong [1 Attachment]

dh..
salam be excel..
saya ada tarikan data dari program yang datanya ada kolom kolom yang kosong.. biasanya saya hpus kolom2 kosong tersebut satu persatu..

adkah cara untuk hapus kolom kosong tersebut bersamaan??

untuk jelasnya file terlampir..

salam
liem

Wed Jun 17, 2015 3:12 am (PDT) . Posted by:

"Nang Agus"

Cara pak hendrik saya coba OK OK saja,

2015-06-17 16:48 GMT+07:00 Hendrik Karnadi hendrikkarnadi@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Hai Liem,
> Satu record kan terdiri satu baris dan bbrp kolom, jadi kalau ada suatu
> invoive yang terdiri dari beberapa baris (sub item) tentunya kolom yg ada
> judulnya tidak boleh kosong...apalagi dihapus.
>
> Mr. Kid mungkin bisa menambahkan coretannya mengenai database yang
> baik.....yang juga sering dibahas sebelunnya.
>
> Salam,
> HK
>
>
> Sent from Samsung Mobile
>
>
> -------- Original message --------
> From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]"
> Date:17/06/2015 2:15 PM (GMT+07:00)
> To: belajar-excel@yahoogroups.com
> Subject: Bls: [belajar-excel] hapus kolom kosong
>
>
>
> pak hk..
> sudah saya coba untuk solusi pak hk tp ketika data misal di kolom J
> datanya kan gak rapat.. jadiny belum sesuai keinginan
> maksud saya kolom yang gak ada headernya yng gak di hapus pak..
>
>
> salam
> liem
>
>
>
> Pada Rabu, 17 Juni 2015 13:59, "Hendrik Karnadi hendrikkarnadi@yahoo.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
> Hai Liem,
> Coba lakukan langkag berikut ini:
> - blok datanya dari kolom awal smp akhir
> - Tekan tombol F5 lalu pilih blanks
> - Tekan tombol del.
>
> Salam,
> HK
>
>
> Sent from Samsung Mobile
>
>
> -------- Original message --------
> From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]"
> Date:17/06/2015 12:08 PM (GMT+07:00)
> To: belajar-excel@yahoogroups.com
> Subject: [belajar-excel] hapus kolom kosong [1 Attachment]
>
>
> dh..
> salam be excel..
> saya ada tarikan data dari program yang datanya ada kolom kolom yang
> kosong.. biasanya saya hpus kolom2 kosong tersebut satu persatu..
>
> adkah cara untuk hapus kolom kosong tersebut bersamaan??
>
> untuk jelasnya file terlampir..
>
>
> salam
> liem
>
>
>
>
>

Wed Jun 17, 2015 9:56 am (PDT) . Posted by:

"lkm jktind" lkmjkt

Bu .

Kalau kolom yang gak ada headernya yng di hapus.

Cara : Blok semua data -----> tekan F5 ---> pilih Blank ----> tekan Ctrl
dan tombol - (minus) ---> pilih Shift cells left----> OK

Salam

Lukman

2015-06-17 16:50 GMT+07:00 Nang Agus nangagus@gmail.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Cara pak hendrik saya coba OK OK saja,
>
> 2015-06-17 16:48 GMT+07:00 Hendrik Karnadi hendrikkarnadi@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>>
>>
>> Hai Liem,
>> Satu record kan terdiri satu baris dan bbrp kolom, jadi kalau ada suatu
>> invoive yang terdiri dari beberapa baris (sub item) tentunya kolom yg ada
>> judulnya tidak boleh kosong...apalagi dihapus.
>>
>> Mr. Kid mungkin bisa menambahkan coretannya mengenai database yang
>> baik.....yang juga sering dibahas sebelunnya.
>>
>> Salam,
>> HK
>>
>>
>> Sent from Samsung Mobile
>>
>>
>> -------- Original message --------
>> From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]"
>> Date:17/06/2015 2:15 PM (GMT+07:00)
>> To: belajar-excel@yahoogroups.com
>> Subject: Bls: [belajar-excel] hapus kolom kosong
>>
>>
>>
>> pak hk..
>> sudah saya coba untuk solusi pak hk tp ketika data misal di kolom J
>> datanya kan gak rapat.. jadiny belum sesuai keinginan
>> maksud saya kolom yang gak ada headernya yng gak di hapus pak..
>>
>>
>> salam
>> liem
>>
>>
>>
>> Pada Rabu, 17 Juni 2015 13:59, "Hendrik Karnadi
>> hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
>> menulis:
>>
>>
>>
>> Hai Liem,
>> Coba lakukan langkag berikut ini:
>> - blok datanya dari kolom awal smp akhir
>> - Tekan tombol F5 lalu pilih blanks
>> - Tekan tombol del.
>>
>> Salam,
>> HK
>>
>>
>> Sent from Samsung Mobile
>>
>>
>> -------- Original message --------
>> From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]"
>> Date:17/06/2015 12:08 PM (GMT+07:00)
>> To: belajar-excel@yahoogroups.com
>> Subject: [belajar-excel] hapus kolom kosong [1 Attachment]
>>
>>
>> dh..
>> salam be excel..
>> saya ada tarikan data dari program yang datanya ada kolom kolom yang
>> kosong.. biasanya saya hpus kolom2 kosong tersebut satu persatu..
>>
>> adkah cara untuk hapus kolom kosong tersebut bersamaan??
>>
>> untuk jelasnya file terlampir..
>>
>>
>> salam
>> liem
>>
>>
>>
>>
>
>

Wed Jun 17, 2015 5:55 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Husnul,

Berikut filenya dgn menggunakan ComboBox.

TerimaKasih.

Sent from Yahoo Mail on Android

Wed Jun 17, 2015 11:04 am (PDT) . Posted by:

"HUSNUL FAIZIN"

terimakasih banyak atas solusi yang diberikan master toby....!

2015-06-17 19:54 GMT+07:00 Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:

>
>
> Dear Husnul,
>
> Berikut filenya dgn menggunakan ComboBox.
>
> TerimaKasih.
>
> Sent from Yahoo Mail on Android
> <http://overview.mail.yahoo.com/mobile/?.src=Android>
>
> ------------------------------
> * From: * HUSNUL FAIZIN husnulfaizin1807@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>;
> * To: * <belajar-excel@yahoogroups.com>;
> * Subject: * [belajar-excel] macro Autoheight_row [1 Attachment]

> * Sent: * Wed, Jun 17, 2015 3:42:51 AM
>
>
>
> Yth. Para Master Bexcel, mohon bantuannya perbaikan script macro pada
> sheets2 agar bisa autofit_row meskipun dalam keadaan merge cell. lebih
> jelasnya sesuai lampiran.
>
> Terimakasih sebelumnya
>
> Wassalam.
>
>
>

Wed Jun 17, 2015 11:04 am (PDT) . Posted by:

"nurani alkena" alkenanurani

mister makasih banyak atas jawaban2 nya. saya minta maaf pertanyaan diatas tidak jadi saya tanyakan...sudah ketemu solusinyamohon maaf lahir batin.....

On Wednesday, June 17, 2015 2:45 PM, "alkenanurani@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Terima kasih atas jawaban yang sudah diberikan dari topik-topik sebelumnya.Mr saya mau tanya lagi... saya memiliki sheet yang terproteksi dan saya memiliki commandbutton untuk perintah copy. ketika saya mencopy data tersebut ke deactive workbook kemudian menempelkan data tersebut menggunakan perintah paste. saya menginginkan perintah paste nya hanya berupa value dgn formatya tetap ???. bagaimana code di deactive workbooknya. karena saya sudah mencoba paste value and format tetapi hasilnya masih berupa rumus dan format. 
Terima Kasih #yiv2817736698 #yiv2817736698 -- #yiv2817736698ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2817736698 #yiv2817736698ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2817736698 #yiv2817736698ygrp-mkp #yiv2817736698hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2817736698 #yiv2817736698ygrp-mkp #yiv2817736698ads {margin-bottom:10px;}#yiv2817736698 #yiv2817736698ygrp-mkp .yiv2817736698ad {padding:0 0;}#yiv2817736698 #yiv2817736698ygrp-mkp .yiv2817736698ad p {margin:0;}#yiv2817736698 #yiv2817736698ygrp-mkp .yiv2817736698ad a {color:#0000ff;text-decoration:none;}#yiv2817736698 #yiv2817736698ygrp-sponsor #yiv2817736698ygrp-lc {font-family:Arial;}#yiv2817736698 #yiv2817736698ygrp-sponsor #yiv2817736698ygrp-lc #yiv2817736698hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2817736698 #yiv2817736698ygrp-sponsor #yiv2817736698ygrp-lc .yiv2817736698ad {margin-bottom:10px;padding:0 0;}#yiv2817736698 #yiv2817736698actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2817736698 #yiv2817736698activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2817736698 #yiv2817736698activity span {font-weight:700;}#yiv2817736698 #yiv2817736698activity span:first-child {text-transform:uppercase;}#yiv2817736698 #yiv2817736698activity span a {color:#5085b6;text-decoration:none;}#yiv2817736698 #yiv2817736698activity span span {color:#ff7900;}#yiv2817736698 #yiv2817736698activity span .yiv2817736698underline {text-decoration:underline;}#yiv2817736698 .yiv2817736698attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2817736698 .yiv2817736698attach div a {text-decoration:none;}#yiv2817736698 .yiv2817736698attach img {border:none;padding-right:5px;}#yiv2817736698 .yiv2817736698attach label {display:block;margin-bottom:5px;}#yiv2817736698 .yiv2817736698attach label a {text-decoration:none;}#yiv2817736698 blockquote {margin:0 0 0 4px;}#yiv2817736698 .yiv2817736698bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2817736698 .yiv2817736698bold a {text-decoration:none;}#yiv2817736698 dd.yiv2817736698last p a {font-family:Verdana;font-weight:700;}#yiv2817736698 dd.yiv2817736698last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2817736698 dd.yiv2817736698last p span.yiv2817736698yshortcuts {margin-right:0;}#yiv2817736698 div.yiv2817736698attach-table div div a {text-decoration:none;}#yiv2817736698 div.yiv2817736698attach-table {width:400px;}#yiv2817736698 div.yiv2817736698file-title a, #yiv2817736698 div.yiv2817736698file-title a:active, #yiv2817736698 div.yiv2817736698file-title a:hover, #yiv2817736698 div.yiv2817736698file-title a:visited {text-decoration:none;}#yiv2817736698 div.yiv2817736698photo-title a, #yiv2817736698 div.yiv2817736698photo-title a:active, #yiv2817736698 div.yiv2817736698photo-title a:hover, #yiv2817736698 div.yiv2817736698photo-title a:visited {text-decoration:none;}#yiv2817736698 div#yiv2817736698ygrp-mlmsg #yiv2817736698ygrp-msg p a span.yiv2817736698yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2817736698 .yiv2817736698green {color:#628c2a;}#yiv2817736698 .yiv2817736698MsoNormal {margin:0 0 0 0;}#yiv2817736698 o {font-size:0;}#yiv2817736698 #yiv2817736698photos div {float:left;width:72px;}#yiv2817736698 #yiv2817736698photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2817736698 #yiv2817736698photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2817736698 #yiv2817736698reco-category {font-size:77%;}#yiv2817736698 #yiv2817736698reco-desc {font-size:77%;}#yiv2817736698 .yiv2817736698replbq {margin:4px;}#yiv2817736698 #yiv2817736698ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2817736698 #yiv2817736698ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2817736698 #yiv2817736698ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2817736698 #yiv2817736698ygrp-mlmsg select, #yiv2817736698 input, #yiv2817736698 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2817736698 #yiv2817736698ygrp-mlmsg pre, #yiv2817736698 code {font:115% monospace;}#yiv2817736698 #yiv2817736698ygrp-mlmsg * {line-height:1.22em;}#yiv2817736698 #yiv2817736698ygrp-mlmsg #yiv2817736698logo {padding-bottom:10px;}#yiv2817736698 #yiv2817736698ygrp-msg p a {font-family:Verdana;}#yiv2817736698 #yiv2817736698ygrp-msg p#yiv2817736698attach-count span {color:#1E66AE;font-weight:700;}#yiv2817736698 #yiv2817736698ygrp-reco #yiv2817736698reco-head {color:#ff7900;font-weight:700;}#yiv2817736698 #yiv2817736698ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2817736698 #yiv2817736698ygrp-sponsor #yiv2817736698ov li a {font-size:130%;text-decoration:none;}#yiv2817736698 #yiv2817736698ygrp-sponsor #yiv2817736698ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2817736698 #yiv2817736698ygrp-sponsor #yiv2817736698ov ul {margin:0;padding:0 0 0 8px;}#yiv2817736698 #yiv2817736698ygrp-text {font-family:Georgia;}#yiv2817736698 #yiv2817736698ygrp-text p {margin:0 0 1em 0;}#yiv2817736698 #yiv2817736698ygrp-text tt {font-size:120%;}#yiv2817736698 #yiv2817736698ygrp-vital ul li:last-child {border-right:none !important;}#yiv2817736698

Wed Jun 17, 2015 10:06 pm (PDT) . Posted by:

"Fajar Fatahillah" fajar.fatahillah

Dear Para Master Excel,sebelumnya saya ucapkan selamat menjalankan puasa ramadhan
saya ada kasus tentang gambar di excel nih, dan ini pekerjaan berulang, yaitu delete gambar existing dengan gambar baru dengan cara paste value picture..caranya gimana ya?
:D

 Best Regards,
Fajar Fatahillah

On Thursday, June 18, 2015 1:04 AM, "nurani alkena alkenanurani@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  mister makasih banyak atas jawaban2 nya. saya minta maaf pertanyaan diatas tidak jadi saya tanyakan...sudah ketemu solusinyamohon maaf lahir batin.....

On Wednesday, June 17, 2015 2:45 PM, "alkenanurani@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Terima kasih atas jawaban yang sudah diberikan dari topik-topik sebelumnya.Mr saya mau tanya lagi... saya memiliki sheet yang terproteksi dan saya memiliki commandbutton untuk perintah copy. ketika saya mencopy data tersebut ke deactive workbook kemudian menempelkan data tersebut menggunakan perintah paste. saya menginginkan perintah paste nya hanya berupa value dgn formatya tetap ???. bagaimana code di deactive workbooknya. karena saya sudah mencoba paste value and format tetapi hasilnya masih berupa rumus dan format. 
Terima Kasih

#yiv0554648593 #yiv0554648593 -- #yiv0554648593ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0554648593 #yiv0554648593ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0554648593 #yiv0554648593ygrp-mkp #yiv0554648593hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0554648593 #yiv0554648593ygrp-mkp #yiv0554648593ads {margin-bottom:10px;}#yiv0554648593 #yiv0554648593ygrp-mkp .yiv0554648593ad {padding:0 0;}#yiv0554648593 #yiv0554648593ygrp-mkp .yiv0554648593ad p {margin:0;}#yiv0554648593 #yiv0554648593ygrp-mkp .yiv0554648593ad a {color:#0000ff;text-decoration:none;}#yiv0554648593 #yiv0554648593ygrp-sponsor #yiv0554648593ygrp-lc {font-family:Arial;}#yiv0554648593 #yiv0554648593ygrp-sponsor #yiv0554648593ygrp-lc #yiv0554648593hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0554648593 #yiv0554648593ygrp-sponsor #yiv0554648593ygrp-lc .yiv0554648593ad {margin-bottom:10px;padding:0 0;}#yiv0554648593 #yiv0554648593actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0554648593 #yiv0554648593activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0554648593 #yiv0554648593activity span {font-weight:700;}#yiv0554648593 #yiv0554648593activity span:first-child {text-transform:uppercase;}#yiv0554648593 #yiv0554648593activity span a {color:#5085b6;text-decoration:none;}#yiv0554648593 #yiv0554648593activity span span {color:#ff7900;}#yiv0554648593 #yiv0554648593activity span .yiv0554648593underline {text-decoration:underline;}#yiv0554648593 .yiv0554648593attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0554648593 .yiv0554648593attach div a {text-decoration:none;}#yiv0554648593 .yiv0554648593attach img {border:none;padding-right:5px;}#yiv0554648593 .yiv0554648593attach label {display:block;margin-bottom:5px;}#yiv0554648593 .yiv0554648593attach label a {text-decoration:none;}#yiv0554648593 blockquote {margin:0 0 0 4px;}#yiv0554648593 .yiv0554648593bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0554648593 .yiv0554648593bold a {text-decoration:none;}#yiv0554648593 dd.yiv0554648593last p a {font-family:Verdana;font-weight:700;}#yiv0554648593 dd.yiv0554648593last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0554648593 dd.yiv0554648593last p span.yiv0554648593yshortcuts {margin-right:0;}#yiv0554648593 div.yiv0554648593attach-table div div a {text-decoration:none;}#yiv0554648593 div.yiv0554648593attach-table {width:400px;}#yiv0554648593 div.yiv0554648593file-title a, #yiv0554648593 div.yiv0554648593file-title a:active, #yiv0554648593 div.yiv0554648593file-title a:hover, #yiv0554648593 div.yiv0554648593file-title a:visited {text-decoration:none;}#yiv0554648593 div.yiv0554648593photo-title a, #yiv0554648593 div.yiv0554648593photo-title a:active, #yiv0554648593 div.yiv0554648593photo-title a:hover, #yiv0554648593 div.yiv0554648593photo-title a:visited {text-decoration:none;}#yiv0554648593 div#yiv0554648593ygrp-mlmsg #yiv0554648593ygrp-msg p a span.yiv0554648593yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0554648593 .yiv0554648593green {color:#628c2a;}#yiv0554648593 .yiv0554648593MsoNormal {margin:0 0 0 0;}#yiv0554648593 o {font-size:0;}#yiv0554648593 #yiv0554648593photos div {float:left;width:72px;}#yiv0554648593 #yiv0554648593photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0554648593 #yiv0554648593photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0554648593 #yiv0554648593reco-category {font-size:77%;}#yiv0554648593 #yiv0554648593reco-desc {font-size:77%;}#yiv0554648593 .yiv0554648593replbq {margin:4px;}#yiv0554648593 #yiv0554648593ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0554648593 #yiv0554648593ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0554648593 #yiv0554648593ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0554648593 #yiv0554648593ygrp-mlmsg select, #yiv0554648593 input, #yiv0554648593 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0554648593 #yiv0554648593ygrp-mlmsg pre, #yiv0554648593 code {font:115% monospace;}#yiv0554648593 #yiv0554648593ygrp-mlmsg * {line-height:1.22em;}#yiv0554648593 #yiv0554648593ygrp-mlmsg #yiv0554648593logo {padding-bottom:10px;}#yiv0554648593 #yiv0554648593ygrp-msg p a {font-family:Verdana;}#yiv0554648593 #yiv0554648593ygrp-msg p#yiv0554648593attach-count span {color:#1E66AE;font-weight:700;}#yiv0554648593 #yiv0554648593ygrp-reco #yiv0554648593reco-head {color:#ff7900;font-weight:700;}#yiv0554648593 #yiv0554648593ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0554648593 #yiv0554648593ygrp-sponsor #yiv0554648593ov li a {font-size:130%;text-decoration:none;}#yiv0554648593 #yiv0554648593ygrp-sponsor #yiv0554648593ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0554648593 #yiv0554648593ygrp-sponsor #yiv0554648593ov ul {margin:0;padding:0 0 0 8px;}#yiv0554648593 #yiv0554648593ygrp-text {font-family:Georgia;}#yiv0554648593 #yiv0554648593ygrp-text p {margin:0 0 1em 0;}#yiv0554648593 #yiv0554648593ygrp-text tt {font-size:120%;}#yiv0554648593 #yiv0554648593ygrp-vital ul li:last-child {border-right:none !important;}#yiv0554648593

Wed Jun 17, 2015 7:37 pm (PDT) . Posted by:

"Dede"

Dear Be Exceller,

Mohon bantuannya untuk koreksi makro ini :

Sub Macro4()
Jmlhbrs = Range("a1").Value
Range("a2").Select
For i = 1 To Jmlhbrs
ActiveCell.Offset(1, 0).Select
j = ActiveCell.Value
On Error Resume Next
Workbooks.Open Filename:="D:\BAD STOCK\Master&#92;STD-STM PMA - Copy.xlsb"
ActiveSheet.Unprotect Password:="a"
Range("a6").Value = j
Range("c4").Value = s
Range("" & s & "+1,1:C100&quot;).Select
Selection.Locked = False
Selection.FormulaHidden = True
Range("c6:" & s & "").Select
Selection.Locked = True
Selection.FormulaHidden = True
ActiveSheet.Protect Password:="a"
ChDir "D:\BAD STOCK\Email&quot;
ActiveWorkbook.SaveAs Filename:="D:\BAD STOCK\Email&#92;" & j & ".xlsb", _
FileFormat:=xlExcel12, CreateBackup:=False
ActiveWindow.Close
Next i
End Sub

Harapannya pada saat makro dijalankan, kolom C pada file terlampir dimana terdapat kode barang maka range tersebut dalam keadaan ter-"Locked&quot;.

Demikian dan terima kasih.

Salam,
DD

________________________________
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

Wed Jun 17, 2015 9:31 pm (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear DD, Coba  buat commonButton dan masukan program ini: Dim jmlhbaris As Integerjmlhbaris = Sheet4.Range("C4").ValueActiveSheet.Unprotect Password:="a"Sheet4.Range(Cells(6, 3), Cells(jmlhbaris, 3)).Select
Selection.Locked = True
Selection.FormulaHidden = True ActiveSheet.Protect DrawingObjects:=False, _
Contents:=True, Scenarios:=False, _
AllowFormattingCells:=True, _
AllowFormattingColumns:=True, _
AllowFormattingRows:=True, _
AllowInsertingColumns:=True, _
AllowInsertingRows:=True, _
AllowInsertingHyperlinks:=True, _
AllowDeletingColumns:=True, _
AllowDeletingRows:=True, _
AllowSorting:=True, _
AllowFiltering:=True, _
AllowUsingPivotTables:=TrueActiveSheet.Protect Password:="a"  TerimaKasih.

Pada Kamis, 18 Juni 2015 9:37, "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Be Exceller,   Mohon bantuannya untuk koreksi makro ini :   Sub Macro4()         Jmlhbrs = Range("a1").Value     Range("a2").Select For i = 1 To Jmlhbrs         ActiveCell.Offset(1, 0).Select         j = ActiveCell.Value       On Error Resume Next       Workbooks.Open Filename:="D:\BAD STOCK\Master&#92;STD-STM PMA - Copy.xlsb"       ActiveSheet.Unprotect Password:="a"       Range("a6").Value = j       Range("c4").Value = s       Range("" & s & "+1,1:C100&quot;).Select       Selection.Locked = False       Selection.FormulaHidden = True       Range("c6:" & s & "").Select       Selection.Locked = True       Selection.FormulaHidden = True       ActiveSheet.Protect Password:="a"       ChDir "D:\BAD STOCK\Email&quot;       ActiveWorkbook.SaveAs Filename:="D:\BAD STOCK\Email&#92;" & j & ".xlsb", _       FileFormat:=xlExcel12, CreateBackup:=False       ActiveWindow.Close Next i End Sub   Harapannya pada saat makro dijalankan, kolom C pada file terlampir dimana terdapat kode barang maka range tersebut dalam keadaan ter-"Locked".   Demikian dan terima kasih.   Salam, DD
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
#yiv5617417509 #yiv5617417509 -- #yiv5617417509ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5617417509 #yiv5617417509ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5617417509 #yiv5617417509ygrp-mkp #yiv5617417509hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5617417509 #yiv5617417509ygrp-mkp #yiv5617417509ads {margin-bottom:10px;}#yiv5617417509 #yiv5617417509ygrp-mkp .yiv5617417509ad {padding:0 0;}#yiv5617417509 #yiv5617417509ygrp-mkp .yiv5617417509ad p {margin:0;}#yiv5617417509 #yiv5617417509ygrp-mkp .yiv5617417509ad a {color:#0000ff;text-decoration:none;}#yiv5617417509 #yiv5617417509ygrp-sponsor #yiv5617417509ygrp-lc {font-family:Arial;}#yiv5617417509 #yiv5617417509ygrp-sponsor #yiv5617417509ygrp-lc #yiv5617417509hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5617417509 #yiv5617417509ygrp-sponsor #yiv5617417509ygrp-lc .yiv5617417509ad {margin-bottom:10px;padding:0 0;}#yiv5617417509 #yiv5617417509actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5617417509 #yiv5617417509activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5617417509 #yiv5617417509activity span {font-weight:700;}#yiv5617417509 #yiv5617417509activity span:first-child {text-transform:uppercase;}#yiv5617417509 #yiv5617417509activity span a {color:#5085b6;text-decoration:none;}#yiv5617417509 #yiv5617417509activity span span {color:#ff7900;}#yiv5617417509 #yiv5617417509activity span .yiv5617417509underline {text-decoration:underline;}#yiv5617417509 .yiv5617417509attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5617417509 .yiv5617417509attach div a {text-decoration:none;}#yiv5617417509 .yiv5617417509attach img {border:none;padding-right:5px;}#yiv5617417509 .yiv5617417509attach label {display:block;margin-bottom:5px;}#yiv5617417509 .yiv5617417509attach label a {text-decoration:none;}#yiv5617417509 blockquote {margin:0 0 0 4px;}#yiv5617417509 .yiv5617417509bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5617417509 .yiv5617417509bold a {text-decoration:none;}#yiv5617417509 dd.yiv5617417509last p a {font-family:Verdana;font-weight:700;}#yiv5617417509 dd.yiv5617417509last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5617417509 dd.yiv5617417509last p span.yiv5617417509yshortcuts {margin-right:0;}#yiv5617417509 div.yiv5617417509attach-table div div a {text-decoration:none;}#yiv5617417509 div.yiv5617417509attach-table {width:400px;}#yiv5617417509 div.yiv5617417509file-title a, #yiv5617417509 div.yiv5617417509file-title a:active, #yiv5617417509 div.yiv5617417509file-title a:hover, #yiv5617417509 div.yiv5617417509file-title a:visited {text-decoration:none;}#yiv5617417509 div.yiv5617417509photo-title a, #yiv5617417509 div.yiv5617417509photo-title a:active, #yiv5617417509 div.yiv5617417509photo-title a:hover, #yiv5617417509 div.yiv5617417509photo-title a:visited {text-decoration:none;}#yiv5617417509 div#yiv5617417509ygrp-mlmsg #yiv5617417509ygrp-msg p a span.yiv5617417509yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5617417509 .yiv5617417509green {color:#628c2a;}#yiv5617417509 .yiv5617417509MsoNormal {margin:0 0 0 0;}#yiv5617417509 o {font-size:0;}#yiv5617417509 #yiv5617417509photos div {float:left;width:72px;}#yiv5617417509 #yiv5617417509photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5617417509 #yiv5617417509photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5617417509 #yiv5617417509reco-category {font-size:77%;}#yiv5617417509 #yiv5617417509reco-desc {font-size:77%;}#yiv5617417509 .yiv5617417509replbq {margin:4px;}#yiv5617417509 #yiv5617417509ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5617417509 #yiv5617417509ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5617417509 #yiv5617417509ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5617417509 #yiv5617417509ygrp-mlmsg select, #yiv5617417509 input, #yiv5617417509 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5617417509 #yiv5617417509ygrp-mlmsg pre, #yiv5617417509 code {font:115% monospace;}#yiv5617417509 #yiv5617417509ygrp-mlmsg * {line-height:1.22em;}#yiv5617417509 #yiv5617417509ygrp-mlmsg #yiv5617417509logo {padding-bottom:10px;}#yiv5617417509 #yiv5617417509ygrp-msg p a {font-family:Verdana;}#yiv5617417509 #yiv5617417509ygrp-msg p#yiv5617417509attach-count span {color:#1E66AE;font-weight:700;}#yiv5617417509 #yiv5617417509ygrp-reco #yiv5617417509reco-head {color:#ff7900;font-weight:700;}#yiv5617417509 #yiv5617417509ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5617417509 #yiv5617417509ygrp-sponsor #yiv5617417509ov li a {font-size:130%;text-decoration:none;}#yiv5617417509 #yiv5617417509ygrp-sponsor #yiv5617417509ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5617417509 #yiv5617417509ygrp-sponsor #yiv5617417509ov ul {margin:0;padding:0 0 0 8px;}#yiv5617417509 #yiv5617417509ygrp-text {font-family:Georgia;}#yiv5617417509 #yiv5617417509ygrp-text p {margin:0 0 1em 0;}#yiv5617417509 #yiv5617417509ygrp-text tt {font-size:120%;}#yiv5617417509 #yiv5617417509ygrp-vital ul li:last-child {border-right:none !important;}#yiv5617417509

Wed Jun 17, 2015 11:36 pm (PDT) . Posted by:

"Dede"

Dear Mr Toby,

Terima kasih masukannya, akan saya coba dan pelajari terlebih dahulu.

Salam,

DD

From: Toby kenzo tobykenzo@yahoo.co.id [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 18 Juni 2015 11:29
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Tidak bisa Locked Range

Dear DD,

Coba buat commonButton dan masukan program ini:

Dim jmlhbaris As Integer

jmlhbaris = Sheet4.Range("C4").Value

ActiveSheet.Unprotect Password:="a"

Sheet4.Range(Cells(6, 3), Cells(jmlhbaris, 3)).Select

Selection.Locked = True
Selection.FormulaHidden = True

ActiveSheet.Protect DrawingObjects:=False, _
Contents:=True, Scenarios:=False, _
AllowFormattingCells:=True, _
AllowFormattingColumns:=True, _
AllowFormattingRows:=True, _
AllowInsertingColumns:=True, _
AllowInsertingRows:=True, _
AllowInsertingHyperlinks:=True, _
AllowDeletingColumns:=True, _
AllowDeletingRows:=True, _
AllowSorting:=True, _
AllowFiltering:=True, _
AllowUsingPivotTables:=True

ActiveSheet.Protect Password:="a"

TerimaKasih.

Pada Kamis, 18 Juni 2015 9:37, "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Dear Be Exceller,

Mohon bantuannya untuk koreksi makro ini :

Sub Macro4()

Jmlhbrs = Range("a1").Value

Range("a2").Select

For i = 1 To Jmlhbrs

ActiveCell.Offset(1, 0).Select

j = ActiveCell.Value

On Error Resume Next

Workbooks.Open Filename:="D:\BAD STOCK\Master&#92;STD-STM PMA - Copy.xlsb"

ActiveSheet.Unprotect Password:="a"

Range("a6").Value = j

Range("c4").Value = s

Range("" & s & "+1,1:C100&quot;).Select

Selection.Locked = False

Selection.FormulaHidden = True

Range("c6:" & s & "").Select

Selection.Locked = True

Selection.FormulaHidden = True

ActiveSheet.Protect Password:="a"

ChDir "D:\BAD STOCK\Email&quot;

ActiveWorkbook.SaveAs Filename:="D:\BAD STOCK\Email&#92;" & j & ".xlsb", _

FileFormat:=xlExcel12, CreateBackup:=False

ActiveWindow.Close

Next i

End Sub

Harapannya pada saat makro dijalankan, kolom C pada file terlampir dimana terdapat kode barang maka range tersebut dalam keadaan ter-"Locked".

Demikian dan terima kasih.

Salam,

DD

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

Wed Jun 17, 2015 7:41 pm (PDT) . Posted by:

aza_faza

Yth. Para Master excel, mohon bantuannya, tolong dibuatin formula agar row yang bernilai 0 bisa otomatis di HIDDEN...untuk lebih jelasnya saya lampirkan contohnya

Salam
Terima Kasih

Wed Jun 17, 2015 9:59 pm (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Aza, Coba buat Commandbutton dan masukan formula ini: Dim target As String
Dim cari As Range target = 0
Set cari = Cells.Find(what:=target, LookIn:=xlValues, LookAt:=xlValue)
If cari Is Nothing Then
MsgBox "Nilai" & " " & target & " yang anda cari tidak di temukan.", , " "
Else
cari.Select
MsgBox "yang anda cari ketemu..."
cari.EntireRow.Hidden = TrueEnd If
TerimaKasih.

Pada Kamis, 18 Juni 2015 9:42, "aza_faza@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Yth. Para Master excel, mohon bantuannya, tolong dibuatin formula agar row yang bernilai 0 bisa otomatis di HIDDEN...untuk lebih jelasnya saya lampirkan contohnya

Salam
Terima Kasih #yiv8986081834 #yiv8986081834 -- #yiv8986081834ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8986081834 #yiv8986081834ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8986081834 #yiv8986081834ygrp-mkp #yiv8986081834hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8986081834 #yiv8986081834ygrp-mkp #yiv8986081834ads {margin-bottom:10px;}#yiv8986081834 #yiv8986081834ygrp-mkp .yiv8986081834ad {padding:0 0;}#yiv8986081834 #yiv8986081834ygrp-mkp .yiv8986081834ad p {margin:0;}#yiv8986081834 #yiv8986081834ygrp-mkp .yiv8986081834ad a {color:#0000ff;text-decoration:none;}#yiv8986081834 #yiv8986081834ygrp-sponsor #yiv8986081834ygrp-lc {font-family:Arial;}#yiv8986081834 #yiv8986081834ygrp-sponsor #yiv8986081834ygrp-lc #yiv8986081834hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8986081834 #yiv8986081834ygrp-sponsor #yiv8986081834ygrp-lc .yiv8986081834ad {margin-bottom:10px;padding:0 0;}#yiv8986081834 #yiv8986081834actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8986081834 #yiv8986081834activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8986081834 #yiv8986081834activity span {font-weight:700;}#yiv8986081834 #yiv8986081834activity span:first-child {text-transform:uppercase;}#yiv8986081834 #yiv8986081834activity span a {color:#5085b6;text-decoration:none;}#yiv8986081834 #yiv8986081834activity span span {color:#ff7900;}#yiv8986081834 #yiv8986081834activity span .yiv8986081834underline {text-decoration:underline;}#yiv8986081834 .yiv8986081834attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8986081834 .yiv8986081834attach div a {text-decoration:none;}#yiv8986081834 .yiv8986081834attach img {border:none;padding-right:5px;}#yiv8986081834 .yiv8986081834attach label {display:block;margin-bottom:5px;}#yiv8986081834 .yiv8986081834attach label a {text-decoration:none;}#yiv8986081834 blockquote {margin:0 0 0 4px;}#yiv8986081834 .yiv8986081834bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8986081834 .yiv8986081834bold a {text-decoration:none;}#yiv8986081834 dd.yiv8986081834last p a {font-family:Verdana;font-weight:700;}#yiv8986081834 dd.yiv8986081834last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8986081834 dd.yiv8986081834last p span.yiv8986081834yshortcuts {margin-right:0;}#yiv8986081834 div.yiv8986081834attach-table div div a {text-decoration:none;}#yiv8986081834 div.yiv8986081834attach-table {width:400px;}#yiv8986081834 div.yiv8986081834file-title a, #yiv8986081834 div.yiv8986081834file-title a:active, #yiv8986081834 div.yiv8986081834file-title a:hover, #yiv8986081834 div.yiv8986081834file-title a:visited {text-decoration:none;}#yiv8986081834 div.yiv8986081834photo-title a, #yiv8986081834 div.yiv8986081834photo-title a:active, #yiv8986081834 div.yiv8986081834photo-title a:hover, #yiv8986081834 div.yiv8986081834photo-title a:visited {text-decoration:none;}#yiv8986081834 div#yiv8986081834ygrp-mlmsg #yiv8986081834ygrp-msg p a span.yiv8986081834yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8986081834 .yiv8986081834green {color:#628c2a;}#yiv8986081834 .yiv8986081834MsoNormal {margin:0 0 0 0;}#yiv8986081834 o {font-size:0;}#yiv8986081834 #yiv8986081834photos div {float:left;width:72px;}#yiv8986081834 #yiv8986081834photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8986081834 #yiv8986081834photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8986081834 #yiv8986081834reco-category {font-size:77%;}#yiv8986081834 #yiv8986081834reco-desc {font-size:77%;}#yiv8986081834 .yiv8986081834replbq {margin:4px;}#yiv8986081834 #yiv8986081834ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8986081834 #yiv8986081834ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8986081834 #yiv8986081834ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8986081834 #yiv8986081834ygrp-mlmsg select, #yiv8986081834 input, #yiv8986081834 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8986081834 #yiv8986081834ygrp-mlmsg pre, #yiv8986081834 code {font:115% monospace;}#yiv8986081834 #yiv8986081834ygrp-mlmsg * {line-height:1.22em;}#yiv8986081834 #yiv8986081834ygrp-mlmsg #yiv8986081834logo {padding-bottom:10px;}#yiv8986081834 #yiv8986081834ygrp-msg p a {font-family:Verdana;}#yiv8986081834 #yiv8986081834ygrp-msg p#yiv8986081834attach-count span {color:#1E66AE;font-weight:700;}#yiv8986081834 #yiv8986081834ygrp-reco #yiv8986081834reco-head {color:#ff7900;font-weight:700;}#yiv8986081834 #yiv8986081834ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8986081834 #yiv8986081834ygrp-sponsor #yiv8986081834ov li a {font-size:130%;text-decoration:none;}#yiv8986081834 #yiv8986081834ygrp-sponsor #yiv8986081834ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8986081834 #yiv8986081834ygrp-sponsor #yiv8986081834ov ul {margin:0;padding:0 0 0 8px;}#yiv8986081834 #yiv8986081834ygrp-text {font-family:Georgia;}#yiv8986081834 #yiv8986081834ygrp-text p {margin:0 0 1em 0;}#yiv8986081834 #yiv8986081834ygrp-text tt {font-size:120%;}#yiv8986081834 #yiv8986081834ygrp-vital ul li:last-child {border-right:none !important;}#yiv8986081834

Wed Jun 17, 2015 10:07 pm (PDT) . Posted by:

yonikriwul

Terima Kasih perhatiannya Om Toby....
Saya coba meneruskan sheet demi sheet...
kalo masih bingung mohon maaf ngrepotin lagi...
Semoga berkenan...
Salam Hangat
Yoni...

Thu Jun 18, 2015 1:38 am (PDT) . Posted by:

"Agusti Dartius"

Selamat siang
para ahli excel semua, saya mau bertanya lagi nie.
pertanyaan saya ini masih ada hubungannya dengan pertanyaan saya yg sebelumnya yaitu dengan subject menghitung lama akese seorang user dalams ehari.
Pertanyaan berikutnya adalah, bagaimana kita menghitung banyaknya hari kerja dimana dalam data tersebut adanya dua atau lebih data tanggal yang sama.
Untuk selengkapnya ada di file terlampir.
Terima kasihagusti

 

Thu Jun 18, 2015 1:38 am (PDT) . Posted by:

alkenanurani

Mister bagaimana cara mengaktifkan CommandBars Undo and Redo pada event workbook_sheetchange
berikut kodenya
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Target.Font.Color = vbBlue
Dim ctl As CommandBarControl
'Undo
For Each ctl In Application.CommandBars.FindControls(ID:=128)
ctl.Enabled = True
Next ctl
'Redo
For Each ctl In Application.CommandBars.FindControls(ID:=129)
ctl.Enabled = True
Next ctl

End Sub


tapi tetap ndak bsa


============================================================
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