Re: [ITCENTER] Masalah di excel , sheet tidak mau di unhide
bisa pake macro mas... ini kodenya Sub Test() Dim s As Shape On Error Resume Next For Each s In ActiveSheet.Shapes s.Placement = xlMoveAndSize Next End Sub *** setelah itu run macro tsb Insya Allaah semua Row/Column bisa di hide Semoga membantu Cheers Yana Nugraha Original Message - From: alid [EMAIL PROTECTED] To: ITCENTER@yahoogroups.com Sent: Wednesday, April 05, 2006 4:53 PM Subject: [ITCENTER] Masalah di excel , sheet tidak mau di unhide Salam ITers, aku ada permasalahan dengan excel nih, kami biasa menggunakan hide untuk memudahkan membaca data, kemaren kami dapat file yg kolomnya tidak mau di hide, mohon bantuan dari rekan-rekan , gimana cara mengatasinya. salam Khalid ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com -- 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 $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id 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/
[ITCENTER] Masalah di excel , sheet tidak mau di unhide
Salam ITers, aku ada permasalahan dengan excel nih, kami biasa menggunakan hide untuk memudahkan membaca data, kemaren kami dapat file yg kolomnya tidak mau di hide, mohon bantuan dari rekan-rekan , gimana cara mengatasinya. salam Khalid __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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 $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id 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/
Re: [ITCENTER] Masalah di excel , sheet tidak mau di unhide
mungkin sheet nya terproteksi, coba aja cek lewat Tools|Protection|Unprotect Sheet (jika memang sheet terproteksi).. semoga terbantu alid wrote: Salam ITers, aku ada permasalahan dengan excel nih, kami biasa menggunakan hide untuk memudahkan membaca data, kemaren kami dapat file yg kolomnya tidak mau di hide, mohon bantuan dari rekan-rekan , gimana cara mengatasinya. salam Khalid -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- 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 $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id 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/
Re: [ITCENTER] Masalah di Excel
Coba rumus yg ini Ex : Col A1 = 17/09/2004Col B1 = DAY(A1) Trus pd Col B1 ( format cell, Category pilih Custom type ) - Original Message - From: Muhamad Safik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 17, 2004 2:08 PM Subject: [ITCENTER] Masalah di Excel Saya punya data sbb: Tanggal Hari 05/09/2004 .. Gimana formulanya untuk menampilkan dari format tanggal (05 september 2004) menjadi format hari (Minggu/Sunday). -- www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ::: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::: ## Forum: ITCENTER.or.id/forum ## Jobs: ITCENTER.or.id/jobs ## 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! ::: ## Forum: ITCENTER.or.id/forum ## Jobs: ITCENTER.or.id/jobs ## 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/
RE: [ITCENTER] Masalah di Excel
A B Tanggal Hari 05/09/2004 Minggu 06/09/2004 Senin 07/09/2004 Selasa 08/05/2004 Sabtu 09/09/2004 Kamis 10/09/2004 Jumat 11/09/2004 Sabtu 12/09/2004 Minggu 13/09/2004 Senin 24/12/2004 Jumat Langkah1: Blok sel2 kolom B, Klik Kanan = Format Cels = Custom = isikan pada type Langkah2: Isikan sel B2 dengan =A2 seterusnya lakukan untuk seluruh sel di kolom B atau sesuai dengan kehendak anda. Maka setiap anda memasukkan data tanggal di Kolom A maka Kolom B akan terisi tanggal secara langsung. Selamat mencoba !! -Original Message- From: Muhamad Safik [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 14:09 To: [EMAIL PROTECTED] Subject: [ITCENTER] Masalah di Excel Saya punya data sbb: Tanggal Hari 05/09/2004 .. Gimana formulanya untuk menampilkan dari format tanggal (05 september 2004) menjadi format hari (Minggu/Sunday). -- www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ::: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::: ## Forum: ITCENTER.or.id/forum ## Jobs: ITCENTER.or.id/jobs ## 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! ::: ## Forum: ITCENTER.or.id/forum ## Jobs: ITCENTER.or.id/jobs ## 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/
[ITCENTER] Masalah di Excel
Saya punya data sbb: Tanggal Hari 05/09/2004 .. Gimana formulanya untuk menampilkan dari format tanggal (05 september 2004) menjadi format hari (Minggu/Sunday). -- www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ::: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::: ## Forum: ITCENTER.or.id/forum ## Jobs: ITCENTER.or.id/jobs ## 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/
