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