{"id":4451,"date":"2023-07-11T00:25:20","date_gmt":"2023-07-11T00:25:20","guid":{"rendered":"https:\/\/statorials.org\/id\/panel-beku-vba\/"},"modified":"2023-07-11T00:25:20","modified_gmt":"2023-07-11T00:25:20","slug":"panel-beku-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panel-beku-vba\/","title":{"rendered":"Cara membekukan panel menggunakan vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan sintaks berikut di VBA untuk membekukan panel tertentu di lembar kerja Excel:<\/span><\/p>\n

 Sub<\/span> FreezeCertainPanes()\n\nWith<\/span> ActiveWindow\n    If<\/span> .FreezePanes Then<\/span> .FreezePanes = False<\/span>\n    .SplitColumn = 0\n    .SplitRow = 1\n    .FreezePanes = True<\/span>\nEnd With\n<\/span>\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Argumen .SplitColumn<\/strong> menentukan jumlah kolom (mulai dari kiri) yang akan dibekukan.<\/span><\/p>\n
 Argumen .SplitRow<\/strong> menentukan jumlah baris (mulai dari atas) yang akan dibekukan.<\/span><\/p>\n
 Makro khusus ini hanya membekukan baris pertama lembar Excel.<\/span><\/p>\n
 Contoh berikut memperlihatkan cara menggunakan sintaksis ini dalam praktik dengan lembar Excel berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 1: Bekukan baris pertama menggunakan VBA<\/strong><\/span><\/h2>\n
 Kita dapat membuat makro berikut untuk membekukan baris pertama lembar Excel:<\/span><\/span><\/p>\n
 Sub<\/span> FreezeCertainPanes()\n\nWith<\/span> ActiveWindow\n    If<\/span> .FreezePanes Then<\/span> .FreezePanes = False<\/span>\n    .SplitColumn = 0\n    .SplitRow = 1\n    .FreezePanes = True<\/span>\nEnd With\n<\/span>\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Setelah makro ini dijalankan, baris pertama lembar menjadi terhenti:<\/span> <\/p>\n
\"\"<\/p>\n
 Tidak peduli seberapa jauh kita menggulir, baris pertama akan tetap terlihat.<\/span><\/p>\n
 Contoh 2: Bekukan kolom pertama menggunakan VBA<\/strong><\/span><\/h2>\n
 Kita dapat membuat makro berikut untuk membekukan baris pertama lembar Excel:<\/span><\/p>\n
 Sub<\/span> FreezeCertainPanes()\n\nWith<\/span> ActiveWindow\n    If<\/span> .FreezePanes Then<\/span> .FreezePanes = False<\/span>\n    .SplitColumn = 1\n    .SplitRow = 0\n    .FreezePanes = True<\/span>\nEnd With\n<\/span>\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Setelah makro ini dijalankan, kolom pertama lembar tersebut terhenti:<\/span> <\/p>\n
\"\"<\/p>\n
 Terlepas dari jarak yang ditempuh, kolom pertama akan tetap terlihat.<\/span><\/p>\n
 Contoh 3: Bekukan baris dan kolom tertentu menggunakan VBA<\/strong><\/span><\/h2>\n
 Kita dapat membuat makro berikut untuk membekukan 3 baris pertama<\/strong> dan 2 kolom pertama<\/strong> pada lembar Excel:<\/span><\/p>\n
 Sub<\/span> FreezeCertainPanes()\n\nWith<\/span> ActiveWindow\n    If<\/span> .FreezePanes Then<\/span> .FreezePanes = False<\/span>\n    .SplitColumn = 2\n    .SplitRow = 3\n    .FreezePanes = True<\/span>\nEnd With\n<\/span>\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Setelah makro ini dijalankan, 3 baris pertama dan 2 kolom pertama lembar akan dibekukan:<\/span> <\/p>\n
\"\"<\/p>\n
 Berapapun jarak yang ditempuh, 3 baris pertama dan 2 kolom pertama akan tetap terlihat.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menemukan baris yang terakhir digunakan<\/a>
 VBA: Cara menemukan kolom yang terakhir digunakan<\/a>
 VBA: cara menyisipkan banyak baris<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan sintaks berikut di VBA untuk membekukan panel tertentu di lembar kerja Excel: Sub FreezeCertainPanes() With ActiveWindow If .FreezePanes Then .FreezePanes = False .SplitColumn = 0 .SplitRow = 1 .FreezePanes = True End With End Sub Argumen .SplitColumn menentukan jumlah kolom (mulai dari kiri) yang akan dibekukan. Argumen .SplitRow menentukan jumlah baris (mulai […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"\nCara Membekukan Panel Menggunakan VBA (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membekukan panel di Excel menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/panel-beku-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membekukan Panel Menggunakan VBA (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membekukan panel di Excel menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panel-beku-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T00:25:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ar1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/panel-beku-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/panel-beku-vba\/\",\"name\":\"Cara Membekukan Panel Menggunakan VBA (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T00:25:20+00:00\",\"dateModified\":\"2023-07-11T00:25:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membekukan panel di Excel menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panel-beku-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panel-beku-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panel-beku-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membekukan panel menggunakan vba (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membekukan Panel Menggunakan VBA (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara membekukan panel di Excel menggunakan VBA, dengan beberapa contoh.","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:\/\/statorials.org\/id\/panel-beku-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membekukan Panel Menggunakan VBA (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara membekukan panel di Excel menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panel-beku-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T00:25:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ar1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/panel-beku-vba\/","url":"https:\/\/statorials.org\/id\/panel-beku-vba\/","name":"Cara Membekukan Panel Menggunakan VBA (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T00:25:20+00:00","dateModified":"2023-07-11T00:25:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membekukan panel di Excel menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panel-beku-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panel-beku-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panel-beku-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membekukan panel menggunakan vba (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4451"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4451"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4451\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}