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.
[Non-text portions of this message have been removed]
--
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/
