Dear mister...copy paste data manual. saya ingin ada penanda bahwa cell dari
sheet tersebut sudah saya update datanya. keterangan font bisa dijadikan
penanda, tetapi ketika saya coba code diatas... hanya berfungsi ketika mengubah
data manual melalui proses pengetikan. ketika menggunakan fungsi copy paste
data. keterangan font tidak berfungsi kembali...
Terima kasih
On Wednesday, June 3, 2015 8:00 AM, "nurani alkena [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Mister,saya sudah mencoba kode seperti ini : Option ExplicitDim otx
As String
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As
Range)
otx = Target(1, 1).Value
End Sub
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Not otx = "" Then
If Not Target(1, 1).Text = otx Then
Target(1, 1).Font.ColorIndex = 3
End If
End If
End Sub
untuk mengubah data pada cell dengan cara mengetik, kode tersebut bisa
diterapkan. tetapi case saya "ketika saya mengcopy paste date" tidak ada
perubahan font pada cell. bagaimana mister untuk mengatasi masalah tersebut.
Terima kasih
On Monday, June 1, 2015 5:29 PM, "hendrik karnadi [email protected]
[belajar-excel]" <[email protected]> wrote:
Hai Nurani,
Perubahan warna pada sel yang ada dalam Sheet (jika selnya diedit) pernah
dibuat oleh almh CTV.File terlampir.
Salam,HK
NB : Jika yang diinginkan adalah perubahan warna pada Sheet Tab maka perlu
dipikirkan apakah Sheet yang pernah diakses pasti telah berubah/diupdate
datanya (copy paste data).
From: "[email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Sunday, 31 May 2015, 12:12
Subject: [belajar-excel] keterangan sheet yang sudah di isi [1 Attachment]
Hello Mr.
Terima kasih sudah banyak bantu saya. pengetahuan excel saya semakin bertambah.
Kali ini saya mau tanya.Saya punya suatu workbook yang isinya 50sheet.saya
ingin ketika saya mengganti data pada sheet-sheet tsb. terjadi perubahan warna
atau keterangan lain.yang menandakan bahwa sheet tsb sudah saya update datanya
(copy paste data).sehingga tidak ada yang tertinggal (belum di paste data
terbaru atau di paste dua kali. bagaimana caranya mister.butuh pencerahan.
Terima kasihWassalamNurani
#yiv7058474278 #yiv7058474278 -- #yiv7058474278ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7058474278
#yiv7058474278ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7058474278
#yiv7058474278ygrp-mkp #yiv7058474278hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7058474278 #yiv7058474278ygrp-mkp #yiv7058474278ads
{margin-bottom:10px;}#yiv7058474278 #yiv7058474278ygrp-mkp .yiv7058474278ad
{padding:0 0;}#yiv7058474278 #yiv7058474278ygrp-mkp .yiv7058474278ad p
{margin:0;}#yiv7058474278 #yiv7058474278ygrp-mkp .yiv7058474278ad a
{color:#0000ff;text-decoration:none;}#yiv7058474278 #yiv7058474278ygrp-sponsor
#yiv7058474278ygrp-lc {font-family:Arial;}#yiv7058474278
#yiv7058474278ygrp-sponsor #yiv7058474278ygrp-lc #yiv7058474278hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7058474278
#yiv7058474278ygrp-sponsor #yiv7058474278ygrp-lc .yiv7058474278ad
{margin-bottom:10px;padding:0 0;}#yiv7058474278 #yiv7058474278actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7058474278
#yiv7058474278activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7058474278
#yiv7058474278activity span {font-weight:700;}#yiv7058474278
#yiv7058474278activity span:first-child
{text-transform:uppercase;}#yiv7058474278 #yiv7058474278activity span a
{color:#5085b6;text-decoration:none;}#yiv7058474278 #yiv7058474278activity span
span {color:#ff7900;}#yiv7058474278 #yiv7058474278activity span
.yiv7058474278underline {text-decoration:underline;}#yiv7058474278
.yiv7058474278attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7058474278 .yiv7058474278attach div a
{text-decoration:none;}#yiv7058474278 .yiv7058474278attach img
{border:none;padding-right:5px;}#yiv7058474278 .yiv7058474278attach label
{display:block;margin-bottom:5px;}#yiv7058474278 .yiv7058474278attach label a
{text-decoration:none;}#yiv7058474278 blockquote {margin:0 0 0
4px;}#yiv7058474278 .yiv7058474278bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7058474278
.yiv7058474278bold a {text-decoration:none;}#yiv7058474278 dd.yiv7058474278last
p a {font-family:Verdana;font-weight:700;}#yiv7058474278 dd.yiv7058474278last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7058474278
dd.yiv7058474278last p span.yiv7058474278yshortcuts
{margin-right:0;}#yiv7058474278 div.yiv7058474278attach-table div div a
{text-decoration:none;}#yiv7058474278 div.yiv7058474278attach-table
{width:400px;}#yiv7058474278 div.yiv7058474278file-title a, #yiv7058474278
div.yiv7058474278file-title a:active, #yiv7058474278
div.yiv7058474278file-title a:hover, #yiv7058474278 div.yiv7058474278file-title
a:visited {text-decoration:none;}#yiv7058474278 div.yiv7058474278photo-title a,
#yiv7058474278 div.yiv7058474278photo-title a:active, #yiv7058474278
div.yiv7058474278photo-title a:hover, #yiv7058474278
div.yiv7058474278photo-title a:visited {text-decoration:none;}#yiv7058474278
div#yiv7058474278ygrp-mlmsg #yiv7058474278ygrp-msg p a
span.yiv7058474278yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7058474278
.yiv7058474278green {color:#628c2a;}#yiv7058474278 .yiv7058474278MsoNormal
{margin:0 0 0 0;}#yiv7058474278 o {font-size:0;}#yiv7058474278
#yiv7058474278photos div {float:left;width:72px;}#yiv7058474278
#yiv7058474278photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7058474278
#yiv7058474278photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7058474278
#yiv7058474278reco-category {font-size:77%;}#yiv7058474278
#yiv7058474278reco-desc {font-size:77%;}#yiv7058474278 .yiv7058474278replbq
{margin:4px;}#yiv7058474278 #yiv7058474278ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7058474278 #yiv7058474278ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7058474278
#yiv7058474278ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7058474278
#yiv7058474278ygrp-mlmsg select, #yiv7058474278 input, #yiv7058474278 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7058474278
#yiv7058474278ygrp-mlmsg pre, #yiv7058474278 code {font:115%
monospace;}#yiv7058474278 #yiv7058474278ygrp-mlmsg *
{line-height:1.22em;}#yiv7058474278 #yiv7058474278ygrp-mlmsg #yiv7058474278logo
{padding-bottom:10px;}#yiv7058474278 #yiv7058474278ygrp-msg p a
{font-family:Verdana;}#yiv7058474278 #yiv7058474278ygrp-msg
p#yiv7058474278attach-count span {color:#1E66AE;font-weight:700;}#yiv7058474278
#yiv7058474278ygrp-reco #yiv7058474278reco-head
{color:#ff7900;font-weight:700;}#yiv7058474278 #yiv7058474278ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7058474278 #yiv7058474278ygrp-sponsor
#yiv7058474278ov li a {font-size:130%;text-decoration:none;}#yiv7058474278
#yiv7058474278ygrp-sponsor #yiv7058474278ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7058474278
#yiv7058474278ygrp-sponsor #yiv7058474278ov ul {margin:0;padding:0 0 0
8px;}#yiv7058474278 #yiv7058474278ygrp-text
{font-family:Georgia;}#yiv7058474278 #yiv7058474278ygrp-text p {margin:0 0 1em
0;}#yiv7058474278 #yiv7058474278ygrp-text tt {font-size:120%;}#yiv7058474278
#yiv7058474278ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7058474278
