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 #yiv8476414206 -- #yiv8476414206ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8476414206 #yiv8476414206ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8476414206 #yiv8476414206ygrp-mkp #yiv8476414206hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8476414206 #yiv8476414206ygrp-mkp #yiv8476414206ads {margin-bottom:10px;}#yiv8476414206 #yiv8476414206ygrp-mkp .yiv8476414206ad {padding:0 0;}#yiv8476414206 #yiv8476414206ygrp-mkp .yiv8476414206ad p {margin:0;}#yiv8476414206 #yiv8476414206ygrp-mkp .yiv8476414206ad a {color:#0000ff;text-decoration:none;}#yiv8476414206 #yiv8476414206ygrp-sponsor #yiv8476414206ygrp-lc {font-family:Arial;}#yiv8476414206 #yiv8476414206ygrp-sponsor #yiv8476414206ygrp-lc #yiv8476414206hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8476414206 #yiv8476414206ygrp-sponsor #yiv8476414206ygrp-lc .yiv8476414206ad {margin-bottom:10px;padding:0 0;}#yiv8476414206 #yiv8476414206actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8476414206 #yiv8476414206activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8476414206 #yiv8476414206activity span {font-weight:700;}#yiv8476414206 #yiv8476414206activity span:first-child {text-transform:uppercase;}#yiv8476414206 #yiv8476414206activity span a {color:#5085b6;text-decoration:none;}#yiv8476414206 #yiv8476414206activity span span {color:#ff7900;}#yiv8476414206 #yiv8476414206activity span .yiv8476414206underline {text-decoration:underline;}#yiv8476414206 .yiv8476414206attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8476414206 .yiv8476414206attach div a {text-decoration:none;}#yiv8476414206 .yiv8476414206attach img {border:none;padding-right:5px;}#yiv8476414206 .yiv8476414206attach label {display:block;margin-bottom:5px;}#yiv8476414206 .yiv8476414206attach label a {text-decoration:none;}#yiv8476414206 blockquote {margin:0 0 0 4px;}#yiv8476414206 .yiv8476414206bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8476414206 .yiv8476414206bold a {text-decoration:none;}#yiv8476414206 dd.yiv8476414206last p a {font-family:Verdana;font-weight:700;}#yiv8476414206 dd.yiv8476414206last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8476414206 dd.yiv8476414206last p span.yiv8476414206yshortcuts {margin-right:0;}#yiv8476414206 div.yiv8476414206attach-table div div a {text-decoration:none;}#yiv8476414206 div.yiv8476414206attach-table {width:400px;}#yiv8476414206 div.yiv8476414206file-title a, #yiv8476414206 div.yiv8476414206file-title a:active, #yiv8476414206 div.yiv8476414206file-title a:hover, #yiv8476414206 div.yiv8476414206file-title a:visited {text-decoration:none;}#yiv8476414206 div.yiv8476414206photo-title a, #yiv8476414206 div.yiv8476414206photo-title a:active, #yiv8476414206 div.yiv8476414206photo-title a:hover, #yiv8476414206 div.yiv8476414206photo-title a:visited {text-decoration:none;}#yiv8476414206 div#yiv8476414206ygrp-mlmsg #yiv8476414206ygrp-msg p a span.yiv8476414206yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8476414206 .yiv8476414206green {color:#628c2a;}#yiv8476414206 .yiv8476414206MsoNormal {margin:0 0 0 0;}#yiv8476414206 o {font-size:0;}#yiv8476414206 #yiv8476414206photos div {float:left;width:72px;}#yiv8476414206 #yiv8476414206photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8476414206 #yiv8476414206photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8476414206 #yiv8476414206reco-category {font-size:77%;}#yiv8476414206 #yiv8476414206reco-desc {font-size:77%;}#yiv8476414206 .yiv8476414206replbq {margin:4px;}#yiv8476414206 #yiv8476414206ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8476414206 #yiv8476414206ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8476414206 #yiv8476414206ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8476414206 #yiv8476414206ygrp-mlmsg select, #yiv8476414206 input, #yiv8476414206 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8476414206 #yiv8476414206ygrp-mlmsg pre, #yiv8476414206 code {font:115% monospace;}#yiv8476414206 #yiv8476414206ygrp-mlmsg * {line-height:1.22em;}#yiv8476414206 #yiv8476414206ygrp-mlmsg #yiv8476414206logo {padding-bottom:10px;}#yiv8476414206 #yiv8476414206ygrp-msg p a {font-family:Verdana;}#yiv8476414206 #yiv8476414206ygrp-msg p#yiv8476414206attach-count span {color:#1E66AE;font-weight:700;}#yiv8476414206 #yiv8476414206ygrp-reco #yiv8476414206reco-head {color:#ff7900;font-weight:700;}#yiv8476414206 #yiv8476414206ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8476414206 #yiv8476414206ygrp-sponsor #yiv8476414206ov li a {font-size:130%;text-decoration:none;}#yiv8476414206 #yiv8476414206ygrp-sponsor #yiv8476414206ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8476414206 #yiv8476414206ygrp-sponsor #yiv8476414206ov ul {margin:0;padding:0 0 0 8px;}#yiv8476414206 #yiv8476414206ygrp-text {font-family:Georgia;}#yiv8476414206 #yiv8476414206ygrp-text p {margin:0 0 1em 0;}#yiv8476414206 #yiv8476414206ygrp-text tt {font-size:120%;}#yiv8476414206 #yiv8476414206ygrp-vital ul li:last-child {border-right:none !important;}#yiv8476414206
