Alhamdulillah, Terima kasih atas solusinya, running well. Solusi yang saya terapkan langsung ke no 3.
Mau nanya, kenapa hal tsb bisa terjadi. Padahal aktivitas sehari-hari saya hanya sekedar input data,formula dan create/edit vba. Terima kasih sebelumnya. Salam, Rasyid From: [email protected] [mailto:[email protected]] Sent: Thursday, March 12, 2015 9:55 AM To: BeExcel Subject: Re: [belajar-excel] pesan error cannot insert object Hai Rasyid, Yang dilakukan berurutan adalah hal-hal berikut : (berhenti jika sudah bisa atau sudah semuanya dicoba dan tetap tidak bisa) 1. cari tahu nama library (dll) si control yang akan di-insert dan cek di drive system melalui windows explorer (search file itu) 2. cek apakah file nomor 1 itu telah di-register ke OS setempat [nomor 1 dan 2 diutamakan untuk activex control yang bukan bawaan saat install MS Office, karena kadang kala ada activex control yang tidak bisa digunakan dalam worksheet] 3. tutup semua Excel, cari (search file di windows explorer) file dengan ekstensi .exd, jika menemukannya, hapus saja file itu dan coba insert lagi 4. cari file fm20.dll, dan cek apakah sudah teregister dengan baik dalam OS. 5. install ulang ms office dan pastikan item VBA dalam ms shered feature atau semacamnya sudah dicentang Wassalam, Kid On Thu, Mar 12, 2015 at 10:54 AM, 'Contract Mining Assistant, Asam-Asam' [email protected]<mailto:[email protected]> [belajar-excel] <[email protected]<mailto:[email protected]>> wrote: Dear all Member, Mohon untuk solusinya. Kenapa setiap kali ingin insert control / modifikasi VBA selalu tampil message box terlampir. Terima kasih sebelumnya Salam, Rasyid Disclaimer - This message including any attachments and information contained herein ("Message" ) may contain privileged information or otherwise is protected from disclosure. Any unauthorized use of this Message by any person may lead to legal consequences. If you receive this Message in error, or if the recipient of this Message is not the intended recipient or the employee or agent authorized for delivering this Message to the intended recipient you are hereby notified that any disclosure, dissemination, distribution or copying of this Message or let or cause this Message to be disclosed,disseminated, distributed, or copied is strictly prohibited, and please notify the sender by return message and immediately delete this Message from your system. Incoming and outgoing communications using this electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable law and regulations. Unless it is made by the authorized person,any views expressed in this Message are those of the individual sender and may not necessarily reflect the views of PT Arutmin Indonesia. You should check attachments for viruses and defects before opening or using them. We are not liable to recover any injuries caused by virused or defected attachments. Disclaimer - This message including any attachments and information contained herein ("Message" ) may contain privileged information or otherwise is protected from disclosure. Any unauthorized use of this Message by any person may lead to legal consequences. If you receive this Message in error, or if the recipient of this Message is not the intended recipient or the employee or agent authorized for delivering this Message to the intended recipient you are hereby notified that any disclosure, dissemination, distribution or copying of this Message or let or cause this Message to be disclosed,disseminated, distributed, or copied is strictly prohibited, and please notify the sender by return message and immediately delete this Message from your system. Incoming and outgoing communications using this electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable law and regulations. Unless it is made by the authorized person,any views expressed in this Message are those of the individual sender and may not necessarily reflect the views of PT Arutmin Indonesia. You should check attachments for viruses and defects before opening or using them. We are not liable to recover any injuries caused by virused or defected attachments.
