Makasih Mr Kid...memang benar ada sheet yang di hide hehehe....top resepnya... SalamSeismica
Pada Minggu, 27 Agustus 2017 8:29, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: #yiv3549364517 #yiv3549364517 -- #yiv3549364517 .yiv3549364517ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv3549364517 div.yiv3549364517ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv3549364517 div.yiv3549364517photo-title a, #yiv3549364517 div.yiv3549364517photo-title a:active, #yiv3549364517 div.yiv3549364517photo-title a:hover, #yiv3549364517 div.yiv3549364517photo-title a:visited {text-decoration:none;}#yiv3549364517 div.yiv3549364517attach-table div.yiv3549364517attach-row {clear:both;}#yiv3549364517 div.yiv3549364517attach-table div.yiv3549364517attach-row div {float:left;}#yiv3549364517 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv3549364517 div.yiv3549364517ygrp-file {width:30px;}#yiv3549364517 div.yiv3549364517attach-table div.yiv3549364517attach-row div div a {text-decoration:none;}#yiv3549364517 div.yiv3549364517attach-table div.yiv3549364517attach-row div div span {font-weight:normal;}#yiv3549364517 div.yiv3549364517ygrp-file-title {font-weight:bold;}#yiv3549364517 #yiv3549364517 #yiv3549364517 #yiv3549364517 --#yiv3549364517ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3549364517 #yiv3549364517ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3549364517 #yiv3549364517ygrp-mkp #yiv3549364517hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3549364517 #yiv3549364517ygrp-mkp #yiv3549364517ads {margin-bottom:10px;}#yiv3549364517 #yiv3549364517ygrp-mkp .yiv3549364517ad {padding:0 0;}#yiv3549364517 #yiv3549364517ygrp-mkp .yiv3549364517ad p {margin:0;}#yiv3549364517 #yiv3549364517ygrp-mkp .yiv3549364517ad a {color:#0000ff;text-decoration:none;}#yiv3549364517 Wa'alaikumussalam wr wb Hai Seis, Sorry ya, tadi kepencet reject... Notifikasinya tampak seperti named range ter-hide. Coba buat sebuah general module di VBA dan tulis prosedur berikut, kemudian jalankan : public sub Blah() dim n as name for each n in thisworkbook.names n.visible=true next n end sub Kalau sudah dijalankan, coba lihat lagi di name manager. Andai named range bernama 'A' tersebut memang sudah tidak digunakan, maka delete saja.Save workbook. Wassalamu'alaikum wr wbKid 2017-08-27 7:46 GMT+07:00 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com>: --- Mods --- Maaf, tak sengaja (salah mencet) jadi ke-reject --------------- ---------- Forwarded message ---------- From: Zerlinda Seismica <seism...@yahoo.com> To: BeExcel <belajar-excel@yahoogroups.com > Cc: Bcc: Date: Sat, 26 Aug 2017 23:00:24 +0000 (UTC) Subject: Notifikasi Aneh Assalamualaikum wrwb Mohn izin lagi bapak ibu...minta penjelasan dan penanganannya dari bapak ibu notifikasi yg bikin jengkel kalau mucul(seperti biasa ada lampirannya)Makasih ya bapak ibu...selamat istrihat dengan keluarga WasalamSeismica ------------------------------ ---------------------