Pak Kid. Tanya : Atur security macro untuk prompt to. buat mengatur ini ada nya di mana ?
Salam Lukman --- Mods --- xl2003 : Tools -> Macro -> Security xl2007 : Office Button -> Excel Options -> Trust Center -> klik Trust Center Setting xl2010 dengan ribbon : ribbon Menus -> Excel Options -> Trust Center -> klik Trust Center Setting xl2010 dengan menu xl2003 : menu File -> Options -> Trust Center -> klik Trust Center Setting ------------ 2013/4/3 Mr. Kid <[email protected]> > ** > > > Sepertinya karena membuka file ber-VBA. > 1. Coba buka aplikasi Excel kosongan (workbook baru). Atur security macro > untuk prompt to. > 2. Buat salinan file bermasalah tersebut ke sebuah folder baru. > 3. Buka file salinan yang error tadi dan jangan pernah di-Enable jika > keluar opsi. > 4. ke VBE (ALT F11) > 5. lakukan untuk setiap module yang ada > >> double klik nama module di VBProject Explorer > >> klik area tulis script > >> tulis comment apa saja di setiap baris pertama lembar module > >> ke menu Debug -> Compile VBProject > ** jika menu Compile ini masih disable, tulis ulang baris > comment baru dan lakukan ulang proses ini > >> jika bertemu error pada module tersebut, perbaiki module tersebut > 6. save workbook (save as ke nama lain juga boleh) > 7. tutup semua Excel > 8. buka file yang di save di nomor 6 dan coba security Macro di pilih > Enable > > Wassalam, > Kid. > > > > On Wed, Apr 3, 2013 at 7:50 PM, lkm jktind <[email protected]> wrote: > >> ** >> >> >> Excel ku . error . >> >> dengan pesan : >> >> Problem signature: >> Problem Event Name: APPCRASH >> Application Name: EXCEL.EXE >> Application Version: 14.0.4756.1000 >> Application Timestamp: 4b9c0870 >> Fault Module Name: VBE7.DLL >> Fault Module Version: 7.0.15.90 >> Fault Module Timestamp: 4b7b2131 >> Exception Code: c0000005 >> Exception Offset: 0000000000220b24 >> OS Version: 6.1.7600.2.0.0.256.1 >> Locale ID: 1057 >> >> Additional information about the problem: >> LCID: 1033 >> skulcid: 1033 >> >> Read our privacy statement online: >> http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409 >> >> If the online privacy statement is not available, please read our privacy >> statement offline: >> C:\Windows\system32\en-US\erofflps.txt >> >> yg kedua kali nya : >> >> Problem signature: >> Problem Event Name: APPCRASH >> Application Name: EXCEL.EXE >> Application Version: 14.0.4756.1000 >> Application Timestamp: 4b9c0870 >> Fault Module Name: VBE7.DLL >> Fault Module Version: 7.0.15.90 >> Fault Module Timestamp: 4b7b2131 >> Exception Code: c0000005 >> Exception Offset: 00000000000bed60 >> OS Version: 6.1.7600.2.0.0.256.1 >> Locale ID: 1057 >> >> Additional information about the problem: >> LCID: 1033 >> skulcid: 1033 >> >> Read our privacy statement online: >> http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409 >> >> If the online privacy statement is not available, please read our privacy >> statement offline: >> C:\Windows\system32\en-US\erofflps.txt >> >> >> Untuk memperbaikinya , apa yg harus aku lakukan ? >> >> >> Lukman >> >> > > ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [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/
