* Terlampir sample file saya yg ada macronya yakni tombol "RESET".
saya coba jelaskan walaupun saya masih amatir makro berguna untuk melakukan kerja yang berulang-ulang 1. buka file yang akan dimodifikasi 2. klik tools -> makro -> record makro = nama makro bisa diganti sesuai keinginan = makro dapat disimpan pada "this workbook" atau "personal makro workbook" atau ... (tergantung selera deh ) = kemudian akan muncul kotak STOP MAKRO 3. lakukan edit file sesuai selera (seharusnya sebelum makro dijalankan proses dirancang dahulu agar lebih mudah) 4. setelah proses modifikasi selesai maka STOP MAKRO, maka file makro akan disimpan sesuai point 2 tadi. 5. apabila ingin melakukan pekerjaan yang sama pada saat yang berbeda dimana jenis file dan sruktur sama maka setelah file dibuka cukup klik tools -> makro -> pilih nama makro yang disimpan tadi -> RUN, maka file akan berubah sesuai dengan proses modifikasi yang pertama tadi. bila disimpan pada "this workbook" maka file tersebut harus dibuka dahulu, bila pada "personal makro workbook" tidak perlu (menurut sepengetahuan saya lho) selamat mencoba semoga sukses Salam, Agus ----------------------------------------------------------------------------------------------------------------- Wahai station TV, jangan berikan anak kita SINETRON tidak bermutu !!! Berikanlah tayangan berpendidikan baik untuk mereka ! ----- Original Message ----- From: Pujianto, Ciput To: [email protected] Cc: [email protected] Sent: Thursday, February 09, 2006 12:28 PM Subject: [Ida-Krisna Show] cara menjalankan MACRO ada yang bisa bantu bagi ilmunya,cara menggunakan atau menjalankan MACRO pada programs Microsoft Excel.kalau bisa juga kasih contohnya biar cepet cara menggunakannya. terima kasih atas bantuan dari rekan rekan. ---------------------------------------------------------------------------- ------------ This electronic message, including its attachments, is confidential and may be privileged or otherwise protected. The information is solely for the intended recipient. If you are not the intended recipient, this message was sent to you in error and you are hereby advised that any review, disclosure, copying, distribution or use of this message or any of the information included in this message by you is unauthorized and strictly prohibited. If you have received this electronic transmission in error, please immediately and permanently delete this message and notify the sender by return e-mail or by telephoning (62343) 631181. Thank you. <http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3 bst%3b&SG=&RAND=47778&partner=hbtools> Upgrade Your Email - Click here! ********************************************************************* This message and any attachments are solely for the intended recipient. If you are not the intended recipient, disclosure, copying, use or distribution of the information included in this message is prohibited -- Please immediately and permanently delete. [Non-text portions of this message have been removed] ================================================================= "Morning greetings doesn't only mean saying 'Good Morning'. It has silent message saying that I remember you when I wake up. Wish you have a Great Day!" -- Ida Arimurti Jangan lupa simak IDA KRISNA SHOW SENIN HINGGA JUMAT di 99,1 DELTA FM Jam 4 sore hingga 8 malam dan kirim sms di 0818 333 582. ================================================================= SPONSORED LINKS Radio stations Station ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "idakrisnashow" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Tired of hearing the same songs over and over? Listen to Internet Radio! Skip songs. Click to listen to LAUNCHcast! http://us.click.yahoo.com/.mKGzA/HARHAA/kkyPAA/iPMolB/TM --------------------------------------------------------------------~-> ================================================================= "Morning greetings doesn't only mean saying 'Good Morning'. It has silent message saying that I remember you when I wake up. Wish you have a Great Day!" -- Ida Arimurti Jangan lupa simak IDA KRISNA SHOW SENIN HINGGA JUMAT di 99,1 DELTA FM Jam 4 sore hingga 8 malam dan kirim sms di 0818 333 582. ================================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/idakrisnashow/ <*> 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/
