Saya forward e-mail yg pernah mebahas hal ini. Semoga membantu ----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of robiton Sent: 12 Juli 2006 10:18 To: [email protected] Subject: Spam:Re: [ITCENTER] Cara agar file excel tidak bisa diprint Pak arifin, coba pake cara ini. Metode ini bisa dipergunakan tidak hanya mencegah user excel mem-print, tetapi termasuk juga mencegah user untuk Save As Dan sebagainya. 1. Buka file excel dimaksud 2. Masuk ke menu --> Tools --> Macro --> Visual Basic Editor 3. Di environment Visual Basic Editor coba lihat di panel Project (kalo panel ini belum terbuka, silahkan buka lewat menu View --> project explorer) 4. Di panel tersebut, dibawah VBAProject --> Microsoft Excel Objects --> Pilihlah This Workbook 5. Kemudian pindahlah ke panel utama Visual Basic Editornya. 6. Dari dropdown list pilihlah list Workbook, kemudian list sebelah kanannya pilih BeforePrint 7. Lalu isikan kode program sesuka anda disana. Contoh: Private Sub Workbook_BeforePrint(Cancel as Boolean) MsgBox ("Ora entuk di print dhisik kang. Durung wayahe ki ") Cancel = True End Sub 8. Lalu simpan workbook. Smoga membantu. Cheers Robo
[Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## 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/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
