Terima kasih sebelumnya
tapi cara ini akan memprotect seluruh sheet. jadi user tidak bisa
menambahkan entry ke sheet tersebut
Message: 21
Date: Tue, 12 Apr 2005 07:54:35 +0700
From: SuRićNi <[EMAIL PROTECTED]>
Subject: Re: Rumus Exel
Caution : This procedure also prevents the cells that contain the formula
from being edited.
1.. Select the range of cells whose formulas you want to hide. You can
also select nonadjacent ranges or the entire sheet.
2.. On the Format menu, click Cells, and then click the Protection tab.
3.. Select the Hidden check box.
4.. Click OK.
5.. On the Tools menu, point to Protection, and then click Protect Sheet.
6.. Make sure the Protect worksheet and contents of locked cells check
box is selected.
----- Original Message -----
From: "Agoes Susilo" <[EMAIL PROTECTED]>
>
> yang anda tanyakan kurang jelas, yang anda maksud
> membuat rumus fix atau rumus tetap berfungsi untuk
> sel-sel berikutnya namun tetap hiden? coba pakai
> format fixed formula... maka rumus tak akan tampak di
> bar..
>
> --- Muhammad Yani <[EMAIL PROTECTED]> wrote:
> >
> > Dear all
> > Rekan 2x saya mau tanya bagaimana caranya menghidden
> > Rumus di Exel,tapi
> > tidak memprotect sheetnya,jadi rumusnya tidak
> > kelihatan diaddress bar.
--
www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
::: Hapus bagian yang tidak perlu (footer, dst) saat reply! :::
## Jobs: ITCENTER.or.id/jobs ## Bursa: ITCENTER.or.id/bursa ##
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
