{"id":690,"date":"2023-09-27T15:58:58","date_gmt":"2023-09-27T15:58:58","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/activar-hoja\/"},"modified":"2023-12-25T10:22:43","modified_gmt":"2023-12-25T10:22:43","slug":"activar-hoja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/activar-hoja\/","title":{"rendered":"\u00bfc\u00f3mo activar una hoja usando vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2765897004\"><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>Supongamos que est\u00e1 trabajando con varias hojas de trabajo y le resulta dif\u00edcil navegar a una hoja usando una pesta\u00f1a. En esta situaci\u00f3n, puede utilizar el c\u00f3digo VBA para activar cualquier hoja de trabajo.<\/p>\n<p> Y, para escribir c\u00f3digo VBA para esto, debe usar el m\u00e9todo Worksheet.Activate. En este art\u00edculo, me gustar\u00eda compartir con ustedes una manera f\u00e1cil de escribir este c\u00f3digo para activar o seleccionar una hoja de trabajo. Antes de escribir este c\u00f3digo, debes comprender este m\u00e9todo.<\/p>\n<h2 class=\"wp-block-heading\"> Hoja de trabajo. M\u00e9todo de activaci\u00f3n<\/h2>\n<p> En este m\u00e9todo, puede especificar el nombre o n\u00famero de la hoja de trabajo que desea activar. Digamos que necesitas activar la hoja 1, entonces el c\u00f3digo ser\u00e1:<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"Sheet1\").Activate<\/code><\/pre>\n<p> O tambi\u00e9n puedes utilizar n\u00fameros de hoja.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"1\").Activate<\/code><\/pre>\n<p> Entonces el c\u00f3digo final ser\u00e1:<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub ActivateSheet1() Worksheets(\"Sheet1\").Activate End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Ejemplos: activar una hoja de c\u00e1lculo con VBA<\/h2>\n<p> En la vida real, puedes utilizar este m\u00e9todo de diferentes maneras. Aqu\u00ed hay algunos.<\/p>\n<h3 class=\"wp-block-heading\"> 1. Activar una hoja de c\u00e1lculo cuando se abre<\/h3>\n<p> Si desea activar una hoja de trabajo espec\u00edfica cada vez que abre el libro, asigne a este c\u00f3digo VBA el nombre auto_open.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub auto_open() Worksheets(\"Sheet1\").Activate End Su<\/code><\/pre>\n<h3 class=\"wp-block-heading\"> 2. Habilite una hoja de trabajo y oculte todas las dem\u00e1s.<\/h3>\n<p> Quiz\u00e1s desee ir a una hoja de trabajo y ocultar todas las dem\u00e1s hojas de trabajo del libro. Puedes hacer esto usando el siguiente c\u00f3digo.<\/p>\n<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>\n<p> Cambie el nombre de la hoja del c\u00f3digo anterior para que sea m\u00e1s \u00fatil.<\/p>\n<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\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/hoja-clara\/\">BORRAR una hoja completa usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/copiar-hoja\/\">Copiar y mover una hoja en Excel usando VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/\">CONTAR Hojas usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/eliminar-una-hoja-1\/\">ELIMINAR una HOJA usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ocultar-hoja\/\">Ocultar y mostrar una hoja usando VBA en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Supongamos que est\u00e1 trabajando con varias hojas de trabajo y le resulta dif\u00edcil navegar a una hoja usando una pesta\u00f1a. En esta situaci\u00f3n, puede utilizar el c\u00f3digo VBA para activar cualquier hoja de trabajo. Y, para escribir c\u00f3digo VBA para esto, debe usar el m\u00e9todo Worksheet.Activate. En este art\u00edculo, me gustar\u00eda compartir con ustedes una [&hellip;]<\/p>\n","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-690","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>\u00bfc\u00f3mo activar una hoja usando vba?<\/title>\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\/es\/activar-hoja\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo activar una hoja usando vba?\" \/>\n<meta property=\"og:description\" content=\"Supongamos que est\u00e1 trabajando con varias hojas de trabajo y le resulta dif\u00edcil navegar a una hoja usando una pesta\u00f1a. En esta situaci\u00f3n, puede utilizar el c\u00f3digo VBA para activar cualquier hoja de trabajo. Y, para escribir c\u00f3digo VBA para esto, debe usar el m\u00e9todo Worksheet.Activate. En este art\u00edculo, me gustar\u00eda compartir con ustedes una [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/activar-hoja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:22:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\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\/es\/activar-hoja\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/activar-hoja\/\",\"name\":\"\u00bfc\u00f3mo activar una hoja usando vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"datePublished\":\"2023-09-27T15:58:58+00:00\",\"dateModified\":\"2023-12-25T10:22:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/activar-hoja\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/activar-hoja\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/activar-hoja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo activar una hoja usando vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo activar una hoja usando vba?","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\/es\/activar-hoja\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo activar una hoja usando vba?","og_description":"Supongamos que est\u00e1 trabajando con varias hojas de trabajo y le resulta dif\u00edcil navegar a una hoja usando una pesta\u00f1a. En esta situaci\u00f3n, puede utilizar el c\u00f3digo VBA para activar cualquier hoja de trabajo. Y, para escribir c\u00f3digo VBA para esto, debe usar el m\u00e9todo Worksheet.Activate. En este art\u00edculo, me gustar\u00eda compartir con ustedes una [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/activar-hoja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:22:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/activar-hoja\/","url":"https:\/\/exceladvisor.org\/es\/activar-hoja\/","name":"\u00bfc\u00f3mo activar una hoja usando vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"datePublished":"2023-09-27T15:58:58+00:00","dateModified":"2023-12-25T10:22:43+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/activar-hoja\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/activar-hoja\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/activar-hoja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo activar una hoja usando vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=690"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/690\/revisions"}],"predecessor-version":[{"id":786,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/690\/revisions\/786"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}