Dear Mr Kid & all member, Sudah saya coba, akan tetapi hasilnya masih nihil, bahkan saya sudah uninstall tetapi hasilnya masih sama. Ternyata file apapun yang menggunakan VBA yang di buat di PC Server (file_A.xlsb) walaupun hanya sekedar menampilkan MessageBox, begitu file (file_A.xlsb) di Copas di PC Client macronya tidak jalan. Setting security sudah betul saja. Begitu saya alihkan ke mode design untuk membuka jendela VBA, begitu saya run codingnya melalui VBA akan tampil message error yg berbunyi “compile error: Object library invalid or contains references to object definitions that Could not be found”.
Add note: - setiap kali saya bikin command button baru di PC server selalu defaulnya dari commandbutton21 - saat file (file_A.xlsb) yg ada di PC client dibuka dan macronya tidak bisa running, akan tetapi begitu saya menambahkan command button di sheet yg baru tetapi masih di PC client macro berjalan normal, biru saya pindah ke sheet sebelumnya macro tetap tidak bisa jalan. Mohon kiranya bantuan, kalau saja dari mr Kid dan semua member pernah mengalami case seperti ini. Terima kasih sebelumnya. Salam Hormat, Rasyid From: [email protected] [mailto:[email protected]] Sent: Wednesday, January 20, 2016 6:01 PM To: BeExcel Subject: Re: [belajar-excel] membuka file bermakro di PC lain tidak bisa. Hai Rasyid, Coba tutup semua Excel, lalu unduh yang ada disini : (fix dari MS -- lihat agak ke bawah, ada tombol download --) https://support.microsoft.com/en-us/kb/3025036 Unduh yang sesuai (khusus untuk user yang sedang login atau punya akses sebagai admin agar bisa untuk seluruh user) dan jalankan Wassalam, Kid On Wed, Jan 20, 2016 at 1:45 PM, 'Contract Mining Assistant, Asam-Asam' [email protected]<mailto:[email protected]> [belajar-excel] <[email protected]<mailto:[email protected]>> wrote: Dear Toby Kenzo and all members, Jawaban: 1- Ya masih dengan extention xlsm 2- Ya dengan nama file yg sama 3- Ya menjadi commandbutton21 dll. Salam, Rasyid From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] Sent: Wednesday, January 20, 2016 2:22 PM To: [email protected]<mailto:[email protected]> Subject: Bls: [belajar-excel] membuka file bermakro di PC lain tidak bisa. Dear Rasyid, Ada beberapa pertanyaan dari saya tentang masalah yg anda alami saat ini. 1. Apakah pada saat copy Paste ke client filenya tetap berextentiom XLSM..? 2. Apakah pada saat copy Paste ke client dengan nama file yang sama atau tidak..? 3. Apakah perubahan name dari commondbutton berubah menjadi commondbutton21 atau yg lain..? TerimaKasih. -------------------------------------------- Pada Rab, 20/1/16, 'Contract Mining Assistant, Asam-Asam' [email protected]<mailto:[email protected]> [belajar-excel] <[email protected]<mailto:[email protected]>> menulis: Judul: [belajar-excel] membuka file bermakro di PC lain tidak bisa. Kepada: [email protected]<mailto:[email protected]> Tanggal: Rabu, 20 Januari, 2016, 10:27 AM Dear Milis Belajar Excel. Mohon bantuannya. Ilustrasi kasus: Saya mempunya 2 buah file excel, 1.file_server.xlsb 2.file_client.xlsm. Rencana nya file_client.xlsm akan di running di tiap2 PC client, yang mana isi dari file tsb ada makro, formula dan ada bahasa basic nya. Akan tetapi ketika di paste di PC client dan dijalankan, ketika kita mengklik salah satu button yang disisipkan bahasa basic, sama sekali tidak merespon, setelah saya masuk ke jendela VBA ternya name dari button tsb telah berubah Dan tidak ada listing programnya, setelah saya manual bikinkan listing programnya, tetap tombol tsb tidak bereaksi. dan tampil kotak pesan “ compile error: Object library invalid or contains references to object definitions that Could not be found”. Saya sudah mencoba dengan merubah setting di Trush Center dengan mengubah ActiveX Setting dan Macro Setting ke option Enable. Akan tetapi masih error. Mohon bantunnya dan terima kasih sebelumnya. Note: saya pakai Excel 2010. 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. #yiv1861964602 #yiv1861964602 -- #yiv1861964602ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv1861964602 #yiv1861964602ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv1861964602 #yiv1861964602ygrp-mkp #yiv1861964602hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv1861964602 #yiv1861964602ygrp-mkp #yiv1861964602ads { margin-bottom:10px;} #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad { padding:0 0;} #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad p { margin:0;} #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad a { color:#0000ff;text-decoration:none;} #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ygrp-lc { font-family:Arial;} #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ygrp-lc #yiv1861964602hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ygrp-lc .yiv1861964602ad { margin-bottom:10px;padding:0 0;} #yiv1861964602 #yiv1861964602actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv1861964602 #yiv1861964602activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv1861964602 #yiv1861964602activity span { font-weight:700;} #yiv1861964602 #yiv1861964602activity span:first-child { text-transform:uppercase;} #yiv1861964602 #yiv1861964602activity span a { color:#5085b6;text-decoration:none;} #yiv1861964602 #yiv1861964602activity span span { color:#ff7900;} #yiv1861964602 #yiv1861964602activity span .yiv1861964602underline { text-decoration:underline;} #yiv1861964602 .yiv1861964602attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv1861964602 .yiv1861964602attach div a { text-decoration:none;} #yiv1861964602 .yiv1861964602attach img { border:none;padding-right:5px;} #yiv1861964602 .yiv1861964602attach label { display:block;margin-bottom:5px;} #yiv1861964602 .yiv1861964602attach label a { text-decoration:none;} #yiv1861964602 blockquote { margin:0 0 0 4px;} #yiv1861964602 .yiv1861964602bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv1861964602 .yiv1861964602bold a { text-decoration:none;} #yiv1861964602 dd.yiv1861964602last p a { font-family:Verdana;font-weight:700;} #yiv1861964602 dd.yiv1861964602last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv1861964602 dd.yiv1861964602last p span.yiv1861964602yshortcuts { margin-right:0;} #yiv1861964602 div.yiv1861964602attach-table div div a { text-decoration:none;} #yiv1861964602 div.yiv1861964602attach-table { width:400px;} #yiv1861964602 div.yiv1861964602file-title a, #yiv1861964602 div.yiv1861964602file-title a:active, #yiv1861964602 div.yiv1861964602file-title a:hover, #yiv1861964602 div.yiv1861964602file-title a:visited { text-decoration:none;} #yiv1861964602 div.yiv1861964602photo-title a, #yiv1861964602 div.yiv1861964602photo-title a:active, #yiv1861964602 div.yiv1861964602photo-title a:hover, #yiv1861964602 div.yiv1861964602photo-title a:visited { text-decoration:none;} #yiv1861964602 div#yiv1861964602ygrp-mlmsg #yiv1861964602ygrp-msg p a span.yiv1861964602yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv1861964602 .yiv1861964602green { color:#628c2a;} #yiv1861964602 .yiv1861964602MsoNormal { margin:0 0 0 0;} #yiv1861964602 o { font-size:0;} #yiv1861964602 #yiv1861964602photos div { float:left;width:72px;} #yiv1861964602 #yiv1861964602photos div div { border:1px solid #666666;height:62px;overflow:hidden;width:62px;} #yiv1861964602 #yiv1861964602photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv1861964602 #yiv1861964602reco-category { font-size:77%;} #yiv1861964602 #yiv1861964602reco-desc { font-size:77%;} #yiv1861964602 .yiv1861964602replbq { margin:4px;} #yiv1861964602 #yiv1861964602ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv1861964602 #yiv1861964602ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv1861964602 #yiv1861964602ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv1861964602 #yiv1861964602ygrp-mlmsg select, #yiv1861964602 input, #yiv1861964602 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv1861964602 #yiv1861964602ygrp-mlmsg pre, #yiv1861964602 code { font:115% monospace;} #yiv1861964602 #yiv1861964602ygrp-mlmsg * { line-height:1.22em;} #yiv1861964602 #yiv1861964602ygrp-mlmsg #yiv1861964602logo { padding-bottom:10px;} #yiv1861964602 #yiv1861964602ygrp-msg p a { font-family:Verdana;} #yiv1861964602 #yiv1861964602ygrp-msg p#yiv1861964602attach-count span { color:#1E66AE;font-weight:700;} #yiv1861964602 #yiv1861964602ygrp-reco #yiv1861964602reco-head { color:#ff7900;font-weight:700;} #yiv1861964602 #yiv1861964602ygrp-reco { margin-bottom:20px;padding:0px;} #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov li a { font-size:130%;text-decoration:none;} #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov ul { margin:0;padding:0 0 0 8px;} #yiv1861964602 #yiv1861964602ygrp-text { font-family:Georgia;} #yiv1861964602 #yiv1861964602ygrp-text p { margin:0 0 1em 0;} #yiv1861964602 #yiv1861964602ygrp-text tt { font-size:120%;} #yiv1861964602 #yiv1861964602ygrp-vital ul li:last-child { border-right:none !important; } #yiv1861964602 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.
