{"id":689,"date":"2023-09-27T15:58:58","date_gmt":"2023-09-27T15:58:58","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/"},"modified":"2023-12-06T11:34:50","modified_gmt":"2023-12-06T11:34:50","slug":"ativar-planilha","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/","title":{"rendered":"Como ativar uma planilha usando vba?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1428261303\"><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><div class=\"excel-before-content\" id=\"excel-1812839791\"><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>Digamos que voc\u00ea esteja trabalhando com v\u00e1rias planilhas e seja dif\u00edcil navegar at\u00e9 uma planilha usando uma guia. Nessa situa\u00e7\u00e3o, voc\u00ea pode usar o c\u00f3digo VBA para ativar qualquer planilha.<\/p><p> E, para escrever c\u00f3digo VBA para isso, voc\u00ea precisa usar o m\u00e9todo Worksheet.Activate. Neste artigo, gostaria de compartilhar com voc\u00eas uma maneira f\u00e1cil de escrever este c\u00f3digo para ativar ou selecionar uma planilha. Antes de escrever este c\u00f3digo, voc\u00ea deve compreender este m\u00e9todo.<\/p><h2 class=\"wp-block-heading\"> M\u00e9todo Planilha.Activate<\/h2><p> Neste m\u00e9todo, voc\u00ea pode especificar o nome ou n\u00famero da planilha que deseja ativar. Digamos que voc\u00ea precise ativar a planilha 1, ent\u00e3o o c\u00f3digo ser\u00e1:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"Sheet1\").Activate<\/code><\/pre><p> Ou voc\u00ea tamb\u00e9m pode usar n\u00fameros de folhas.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"1\").Activate<\/code><\/pre><p> Ent\u00e3o o c\u00f3digo final ser\u00e1:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub ActivateSheet1() Worksheets(\"Sheet1\").Activate End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Exemplos: ativar uma planilha com VBA<\/h2><p> Na vida real, voc\u00ea pode usar esse m\u00e9todo de diferentes maneiras. Aqui est\u00e3o alguns.<\/p><h3 class=\"wp-block-heading\"> 1. Ative uma planilha quando aberta<\/h3><p> Se voc\u00ea deseja ativar uma planilha espec\u00edfica sempre que abrir a pasta de trabalho, nomeie esse c\u00f3digo VBA como auto_open.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub auto_open() Worksheets(\"Sheet1\").Activate End Su<\/code><\/pre><h3 class=\"wp-block-heading\"> 2. Habilite uma planilha e oculte todas as outras<\/h3><p> Talvez voc\u00ea queira ir para uma planilha e ocultar todas as outras planilhas da pasta de trabalho. Voc\u00ea pode fazer isso usando o c\u00f3digo abaixo.<\/p><pre class=\"wp-block-code\" title=\"Coded\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub HideWorksheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name &lt;&gt; \"Sheet1\" Then ws.Visible = xlSheetHidden End If Next ws End Sub<\/code><\/pre><p> Altere o nome da planilha do c\u00f3digo acima para torn\u00e1-la mais \u00fatil.<\/p><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\/pt\/vba\/\">O que \u00e9 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/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\/pt\/limpar-folha\/\">LIMPAR uma planilha inteira usando VBA no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/folha-de-copia\/\">Copie e mova uma planilha no Excel usando VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/\">COUNT planilhas usando VBA no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/excluir-uma-planilha-1\/\">EXCLUIR uma FOLHA usando VBA no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/ocultar-planilha\/\">Ocultar e mostrar uma planilha usando VBA no 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-689","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>Como ativar uma planilha usando VBA? (M\u00e9todo 2023)<\/title>\n<meta name=\"description\" content=\"Nessa situa\u00e7\u00e3o, voc\u00ea pode usar o c\u00f3digo VBA para ativar qualquer planilha. E, para escrever c\u00f3digo VBA para\" \/>\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\/pt\/ativar-planilha\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como ativar uma planilha usando VBA? (M\u00e9todo 2023)\" \/>\n<meta property=\"og:description\" content=\"Nessa situa\u00e7\u00e3o, voc\u00ea pode usar o c\u00f3digo VBA para ativar qualquer planilha. E, para escrever c\u00f3digo VBA para\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:34:50+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/\",\"name\":\"Como ativar uma planilha usando VBA? (M\u00e9todo 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"datePublished\":\"2023-09-27T15:58:58+00:00\",\"dateModified\":\"2023-12-06T11:34:50+00:00\",\"description\":\"Nessa situa\u00e7\u00e3o, voc\u00ea pode usar o c\u00f3digo VBA para ativar qualquer planilha. E, para escrever c\u00f3digo VBA para\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como ativar uma planilha usando vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como ativar uma planilha usando VBA? (M\u00e9todo 2023)","description":"Nessa situa\u00e7\u00e3o, voc\u00ea pode usar o c\u00f3digo VBA para ativar qualquer planilha. E, para escrever c\u00f3digo VBA para","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\/pt\/ativar-planilha\/","og_locale":"pt_PT","og_type":"article","og_title":"Como ativar uma planilha usando VBA? (M\u00e9todo 2023)","og_description":"Nessa situa\u00e7\u00e3o, voc\u00ea pode usar o c\u00f3digo VBA para ativar qualquer planilha. E, para escrever c\u00f3digo VBA para","og_url":"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:34:50+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/","url":"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/","name":"Como ativar uma planilha usando VBA? (M\u00e9todo 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"datePublished":"2023-09-27T15:58:58+00:00","dateModified":"2023-12-06T11:34:50+00:00","description":"Nessa situa\u00e7\u00e3o, voc\u00ea pode usar o c\u00f3digo VBA para ativar qualquer planilha. E, para escrever c\u00f3digo VBA para","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/ativar-planilha\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/ativar-planilha\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como ativar uma planilha usando vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=689"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/689\/revisions"}],"predecessor-version":[{"id":857,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/689\/revisions\/857"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}