{"id":1542,"date":"2023-11-17T11:53:36","date_gmt":"2023-11-17T11:53:36","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/"},"modified":"2023-12-06T06:15:48","modified_gmt":"2023-12-06T06:15:48","slug":"aktifkan-buku-kerja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/","title":{"rendered":"Bagaimana cara mengaktifkan buku kerja excel melalui vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1225426230\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Saat Anda bekerja dengan beberapa buku kerja secara bersamaan, maksud saya, ketika Anda membuka beberapa buku kerja secara bersamaan, Anda perlu mengetahui metode yang dapat membantu Anda mengaktifkan buku kerja yang ingin Anda kerjakan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52783\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png\" sizes=\"auto, \" srcset=\"\" alt=\"aktifkan buku kerja\" width=\"404\" height=\"67\"><\/figure><\/div><p> Untuk mengaktifkan workbook menggunakan VBA, Anda harus menggunakan metode Workbook.Activate. Dalam metode ini, Anda perlu menentukan nama buku kerja menggunakan objek Buku Kerja. Ini juga memungkinkan Anda untuk menggunakan nomor buku kerja alih-alih nama buku kerja, namun Anda hanya bisa merujuk ke buku kerja yang terbuka.<\/p><p> Dalam tutorial ini kita melihat berbagai cara untuk menggunakan metode ini.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah untuk mengaktifkan buku kerja <\/h2><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52784\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-types-de-classeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"ketik pengikat\" width=\"447\" height=\"211\"><\/figure><\/div><ol type=\"1\"><li> Ketik \u201cBinders\u201d untuk menggunakan objek binder.<\/li><li> Tentukan nama buku kerja dalam tanda kutip ganda.<\/li><li> Masukkan titik (.) untuk mendapatkan daftar properti dan metode.<\/li><li> Pilih metode Aktifkan dari daftar atau Anda juga dapat memasukkannya.<\/li><li> Pada akhirnya, jalankan kode untuk mengaktifkan buku kerja.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_activate_workbook() Workbooks(\"Book3\").Activate End Sub<\/code><\/pre><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Jika Anda mencoba mengaktifkan buku kerja yang tidak terbuka, VBA akan menampilkan kesalahan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52785\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vba-affichera-une-erreur.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-akan-menampilkan-kesalahan\" width=\"444\" height=\"317\"><\/figure><\/div><p> <strong>Terkait:<\/strong> <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\"><strong>Aktifkan Spreadsheet Menggunakan VBA<\/strong><\/a><\/p><p class=\"content-box-grey\"> <em>Tautan yang berguna: <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/merekam-makro\/\">Perekam makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/editor-visual-dasar\/\">Editor Visual Basic<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/buku-catatan-makro-pribadi\/\">Buku Pegangan Makro Pribadi<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Aktifkan buku kerja menggunakan nomor<\/h2><p> Saat Anda membuka beberapa buku kerja, semua buku kerja ini menjadi bagian dari koleksi buku kerja dan memiliki nomor yang bisa Anda rujuk, lalu Anda bisa menggunakan metode aktivasi dengannya. Ini kodenya: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_activate_workbook() Workbooks(2).Activate End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52786\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-activer-un-classeur-en-utilisant-le-numero.png\" sizes=\"auto, \" srcset=\"\" alt=\"aktifkan-pengikat-menggunakan-nomor\" width=\"401\" height=\"218\"><\/figure><\/div><p> Dan jika Anda mencoba mengaktifkan buku kerja menggunakan nomor yang tidak ada, VBA akan menampilkan Run-time error &#8216;9&#8217; (Subscript out of Range). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52787\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-vba-affichera-lerreur-dexecution-9.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-akan-menunjukkan-run-time-error-9\" width=\"400\" height=\"272\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Aktifkan buku kerja ini<\/h2><p> Anda bisa merujuk ke buku kerja tempat Anda menulis kode menggunakan properti ThisWorkbook. Katakanlah Anda memiliki lima buku kerja yang terbuka pada saat yang sama tetapi Anda sedang mengerjakan &#8220;Book1.xlsm&#8221;, jadi ketika Anda menjalankan kode berikut ini akan mengaktifkan &#8220;Book1.xlsm&#8221;.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_activate_workbook() ThisWorkbook.Activate End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Periksa sebelum mengaktifkan buku kerja<\/h2><p> Seperti yang saya katakan, ketika Anda mencoba mengaktifkan buku kerja yang tidak terbuka, VBA menunjukkan kesalahan kepada Anda. Untuk mengatasi masalah ini, cara terbaik adalah dengan memeriksa terlebih dahulu nama buku kerja (apakah terbuka atau tidak) lalu mengaktifkannya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_activate_workbook() Dim wb As Workbook For Each wb In Workbooks If wb.Name = \"Book3.xlsx\" Then wb.Activate MsgBox \"Workbook found and activated\" Exit Sub End If Next wb MsgBox \"Not found\" End Sub<\/code><\/pre><p> Dengan menggunakan kode di atas Anda dapat menentukan nama buku kerja dan ini pertama-tama akan memeriksa buku kerja ini di semua buku kerja yang terbuka, dan jika menemukan buku kerja tersebut maka akan mengaktifkannya.<\/p><h2 class=\"wp-block-heading\"> Komentar<\/h2><ul><li> Saat menggunakan nama buku kerja, pastikan Anda menggunakan ekstensi file yang benar<\/li><li> Jika Anda ingin mengaktifkan buku kerja yang belum disimpan, Anda harus menggunakan nama buku kerja tersebut saja tanpa menambahkan akhiran file.<\/li><\/ul><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/\">Salin file Excel (buku kerja) menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/\">Tutup buku kerja VBA (file Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/\">VBA Menggabungkan Buku Kerja (File Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/membuat-buku-kerja\/\">VBA Buat buku kerja baru (file Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/\">VBA Hapus Buku Kerja (File Excel)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1542","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara mengaktifkan buku kerja Excel melalui VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Saat Anda membuka beberapa buku kerja secara bersamaan, metode ini dapat membantu Anda menghemat banyak waktu.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mengaktifkan buku kerja Excel melalui VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Saat Anda membuka beberapa buku kerja secara bersamaan, metode ini dapat membantu Anda menghemat banyak waktu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\",\"name\":\"\u25b7 Bagaimana cara mengaktifkan buku kerja Excel melalui VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png\",\"datePublished\":\"2023-11-17T11:53:36+00:00\",\"dateModified\":\"2023-12-06T06:15:48+00:00\",\"description\":\"Saat Anda membuka beberapa buku kerja secara bersamaan, metode ini dapat membantu Anda menghemat banyak waktu.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengaktifkan buku kerja excel melalui vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara mengaktifkan buku kerja Excel melalui VBA? (Tutorial 2023)","description":"Saat Anda membuka beberapa buku kerja secara bersamaan, metode ini dapat membantu Anda menghemat banyak waktu.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengaktifkan buku kerja Excel melalui VBA? (Tutorial 2023)","og_description":"Saat Anda membuka beberapa buku kerja secara bersamaan, metode ini dapat membantu Anda menghemat banyak waktu.","og_url":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:48+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/","url":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/","name":"\u25b7 Bagaimana cara mengaktifkan buku kerja Excel melalui VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png","datePublished":"2023-11-17T11:53:36+00:00","dateModified":"2023-12-06T06:15:48+00:00","description":"Saat Anda membuka beberapa buku kerja secara bersamaan, metode ini dapat membantu Anda menghemat banyak waktu.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-classeur-active.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengaktifkan buku kerja excel melalui vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1542"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1542\/revisions"}],"predecessor-version":[{"id":2455,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1542\/revisions\/2455"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}