Silahkan dicoba
1. Sorot kolom c , klik format, klik format, cell pilih tab protection.
Check box unlock ya...di unclick / kosongkan.
2. pilih tool, protection, protect sheet dan masukan passwordnya
CMIIW
-----Original Message-----
From: ITCENTER@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Handoko Cen
Sent: Wednesday, June 22, 2005 11:41 AM
To: ITCENTER@yahoogroups.com
Subject: [ITCENTER] Blok kolom di Excel
Halo..
Apa ada di antara rekan yang tahu bagaimana caranya mengeblok beberapa kolom
di sheet Excel ?
Jadi, contohnya, saya ingin user tidak bisa mengubah isi kolom A dan B, dan
hanya boleh mengisi data di kolom C dan seterusnya...
Thanks..
Salam,
Handoko
[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 ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
Yahoo! Groups Links
--
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 ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
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/
