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.
