{"id":391,"date":"2018-01-24T06:35:29","date_gmt":"2018-01-24T06:35:29","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=391"},"modified":"2023-10-27T19:18:08","modified_gmt":"2023-10-27T19:18:08","slug":"hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/","title":{"rendered":"Hojas ocultas y visibles en excel: visible, oculta y muy oculta."},"content":{"rendered":"<h2>Hoja visible, hoja oculta y hoja muy oculta en excel<\/h2>\n<p>Respecto a la visibilidad de las hojas, Excel dispone de tres niveles:<\/p>\n<ul>\n<li>Visible (<strong>-1 &#8211; xlSheetVisible<\/strong>),<\/li>\n<li>Oculta (<strong>0 &#8211; xlSheetHidden<\/strong>),<\/li>\n<li>Muy oculta (<strong>2 &#8211; xlSheetHidden<\/strong>)<\/li>\n<\/ul>\n<hr \/>\n<h2>Hojas visibles (<strong>-1 &#8211; xlSheetVisible<\/strong>)<\/h2>\n<p>Son solo eso: las hojas en las que trabajas y manipulas datos de forma cotidiana y a las que puedes acceder con solo seleccionarlas o referirlas en una f\u00f3rmula.<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img01vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-392 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img01vis.png\" alt=\"\" width=\"464\" height=\"366\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img01vis.png 464w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img01vis-300x237.png 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<hr \/>\n<h2>Hojas ocultas (<strong>0 &#8211; xlSheetHidden<\/strong>)<\/h2>\n<p>Se trata de aquellas hojas que no quiere mostrar en tu \u00e1rea de trabajo, pero que f\u00e1cilmente puede &#8220;llamar&#8221; u ocultar con un sol click. Cualquiera con acceso al archivo podr\u00eda hacer visible una hoja oculta.<\/p>\n<p>Para ocultar una hoja y darle este estatus basta un click derecho en el nombre de la hoja que quieres ocultar y dar click en la opci\u00f3n &#8220;ocultar&#8221; (<em>hide<\/em>).<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img02vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-393 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img02vis.png\" alt=\"\" width=\"439\" height=\"275\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img02vis.png 439w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img02vis-300x188.png 300w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><\/p>\n<p>Para mostrar las hojas ocultas basta un click derecho en el nombre de cualquier hoja, dar click en &#8220;mostrar&#8221; (<em>unhide<\/em>) y despu\u00e9s seleccionar la hoja que quieres mostrar.<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img03vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-395 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img03vis.png\" alt=\"\" width=\"396\" height=\"297\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img03vis.png 396w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img03vis-300x225.png 300w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img04vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-396 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img04vis.png\" alt=\"\" width=\"534\" height=\"280\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img04vis.png 534w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img04vis-300x157.png 300w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/a><br \/>\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7741409798\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<hr \/>\n<h2>Hojas muy ocultas (<strong>2 &#8211; xlSheetVeryHidden<\/strong>)<\/h2>\n<p>Se trata de aquellas hojas que no son visibles en tu \u00e1rea de trabajo, y que no puedes mostrar con un procedimiento simple. Se usan cuando quieres ocultar informaci\u00f3n y no quieres mostrarla a ning\u00fan usuario. Agregando un password, el bloqueo es casi total (<strong>\u00a1nadie podr\u00eda ver el contenido de una hoja con estas caracter\u00edsticas!&#8230; <\/strong>Bueno, tenemos un servicio para romper este tipo de bloqueos, b\u00fascanos si necesitas ayuda: info@fditf.com).<\/p>\n<h4>\u00bfC\u00f3mo cambiar una hoja a &#8220;muy oculta&#8221;?<\/h4>\n<p>0. El libro donde se encuentra la hoja que quieres ocultar debe estar abierto. En este caso es nuestro libro &#8220;ejemplo&#8221; que contiene 4 hojas:<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img05vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-398 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img05vis.png\" alt=\"\" width=\"386\" height=\"267\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img05vis.png 386w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img05vis-300x208.png 300w\" sizes=\"auto, (max-width: 386px) 100vw, 386px\" \/><\/a><\/p>\n<p>1. Abre el editor de VBA (<strong>ALT + F11<\/strong>). Debes ver una ventana muy semejante:<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img06vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-399 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img06vis.png\" alt=\"\" width=\"963\" height=\"290\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img06vis.png 963w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img06vis-300x90.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img06vis-768x231.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img06vis-624x188.png 624w\" sizes=\"auto, (max-width: 963px) 100vw, 963px\" \/><\/a><\/p>\n<p>2. Del lado izquierdo hay una lista de las hojas (las mismas que tienes en tu libro. Selecciona (<strong>doble click<\/strong>) la que quieras hacer &#8220;muy oculta&#8221;. En este caso seleccionaremos la hoja &#8220;<strong>Sheet3<\/strong>&#8220;. En la parte inferior se activar\u00e1 la ventana de propiedades (&#8220;<strong>properties<\/strong>&#8220;). En esa ventana, la \u00faltima opci\u00f3n es el campo &#8220;<strong>Visible<\/strong>&#8221; con el valor &#8220;<strong>-1 xlSheetVisible<\/strong>&#8220;.<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img07vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-401 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img07vis.png\" alt=\"\" width=\"536\" height=\"583\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img07vis.png 536w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img07vis-276x300.png 276w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<p>3. Cuando activas esa casilla, aparecen las opciones. Elige &#8220;<strong>2 &#8211; xlSheetVeryHidden<\/strong>&#8220;. Con esto, la hoja queda &#8220;muy oculta&#8221;.<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img08vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-402 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img08vis.png\" alt=\"\" width=\"304\" height=\"336\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img08vis.png 304w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img08vis-271x300.png 271w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/a><\/p>\n<p>La hoja que acabas de ocultar no estar\u00e1 accesible con la opci\u00f3n mostrar. En la imagen notar\u00e1s que &#8220;no hay hojas que mostrar&#8221;, como si ninguna hoja estuviera oculta:<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img09vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-403 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img09vis.png\" alt=\"\" width=\"467\" height=\"299\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img09vis.png 467w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img09vis-300x192.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/a><\/p>\n<p>La informaci\u00f3n no se borr\u00f3, la hoja sigue ah\u00ed, y sus referencias quedan vivas, solo que no hay forma de hacerla visible, a menos que sigas el procedimiento anterior (cambiando el estatus a <strong>xlSheetVisible<\/strong>).<\/p>\n<h4>Protege la informaci\u00f3n con un password.<\/h4>\n<p>Bien. La hoja ya est\u00e1 muy oculta, y la informaci\u00f3n no ser\u00eda visible, a menos que sigas el m\u00e9todo anterior. Pero hay un bloqueo adicional que puedes usar. Toma en cuenta que este m\u00e9todo funciona solo en libros habilitadospara macros. Si ya tienes macros en el mismo libro, omite el siguiente paso, de lo contrario continua y sigue las instrucciones.<\/p>\n<p>Inserta un m\u00f3dulo. En el editor de VBA, Ve al objeto &#8220;<strong>ThisWorkbook<\/strong>&#8221; y da un click derecho para llegar hasta la opci\u00f3n <strong>Insert<\/strong>\/<strong>Module<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img12vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-412 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img12vis.png\" alt=\"\" width=\"587\" height=\"663\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img12vis.png 587w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img12vis-266x300.png 266w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/a><\/p>\n<p>Notar\u00e1s que ahora hay un m\u00f3dulo, no es necesario agregar contenido. Con esto es suficiente para indicar a Excel que tenemos macros. Guarda el libro. Excel te pedir\u00e1 que lo habilites para macros (ser\u00e1 un archivo nuevo). Gu\u00e1rdalo en el formato xlsm.<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img13vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-413 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img13vis.png\" alt=\"\" width=\"614\" height=\"169\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img13vis.png 614w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img13vis-300x83.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img14vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-414 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img14vis.png\" alt=\"\" width=\"931\" height=\"173\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img14vis.png 931w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img14vis-300x56.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img14vis-768x143.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img14vis-624x116.png 624w\" sizes=\"auto, (max-width: 931px) 100vw, 931px\" \/><\/a><\/p>\n<p>En la ventana del editor de VBA (ALT + F11) ve a la opci\u00f3n &#8220;<strong>Herramientas<\/strong>&#8221; (<em><strong>Tools<\/strong><\/em>), y luego a &#8220;<strong>VBA Project Properties<\/strong>&#8221;<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img10vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-408 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img10vis.png\" alt=\"\" width=\"583\" height=\"745\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img10vis.png 583w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img10vis-235x300.png 235w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/a><\/p>\n<p>Ver\u00e1s esta nueva ventana. Ve al tab &#8220;<strong>Protection<\/strong>&#8220;, Activa el checkbox &#8220;<strong>Lock project for viewing<\/strong>&#8221; y pon un password, el que tu quieras.<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img11vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-409 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img11vis.png\" alt=\"\" width=\"669\" height=\"658\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img11vis.png 669w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img11vis-300x295.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img11vis-624x614.png 624w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img11vis-60x60.png 60w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p>Guarda los cambios. Para que veas c\u00f3mo funciona el password, debes cerrar el libro de trabajo, abrirlo, y cuando intentes abrir los detalles del editor de VBA para el archivo de trabajo, notar\u00e1s que est\u00e1 &#8220;cerrado&#8221;, y si das doble click te pedir\u00e1 un password. Sin el password, ser\u00e1 imposible mostrar las hojas &#8220;muy ocultas&#8221;.<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img15vis.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-415 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img15vis.png\" alt=\"\" width=\"593\" height=\"315\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img15vis.png 593w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img15vis-300x159.png 300w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/a><\/p>\n<p>Como lo comentamos arriba, sin password no ser\u00e1 posible cambiar la visibilidad de las hojas muy ocultas, esto mantendr\u00e1 segura tu informaci\u00f3n. Si quieres ayuda para romper un password de este tipo, cont\u00e1ctanos: info@fditf.com.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoja visible, hoja oculta y hoja muy oculta en excel Respecto a la visibilidad de las hojas, Excel dispone de tres niveles: Visible (-1 &#8211; xlSheetVisible), Oculta (0 &#8211; xlSheetHidden), Muy oculta (2 &#8211; xlSheetHidden) Hojas visibles (-1 &#8211; xlSheetVisible) <a href=\"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":3833,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[7,8,21,72,73,71],"class_list":["post-391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-excel","tag-macros","tag-vba","tag-xlsheethidden","tag-xlsheetveryhidden","tag-xlsheetvisible"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hojas ocultas y visibles en excel: visible, oculta y muy oculta. - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"ver hojas ocultas excel, hoja oculta y muy oculta. Todas las modalidades que Excel tiene dsponibles, c\u00f3mo ejecutarlas y descarga el ejemplo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Descubre esta s\u00faper caracter\u00edstica de Excel\" \/>\n<meta property=\"og:description\" content=\"ver hojas ocultas excel, hoja oculta y muy oculta. Todas las modalidades que Excel tiene dsponibles, c\u00f3mo ejecutarlas y descarga el ejemplo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-24T06:35:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T19:18:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/no-face-1563267-1280x960-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"960\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Descubre esta s\u00faper caracter\u00edstica de Excel\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/no-face-1563267-1280x960-1.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"Hojas ocultas y visibles en excel: visible, oculta y muy oculta.\",\"datePublished\":\"2018-01-24T06:35:29+00:00\",\"dateModified\":\"2023-10-27T19:18:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/\"},\"wordCount\":731,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/no-face-1563267-1280x960-1.jpg\",\"keywords\":[\"Excel\",\"Macros\",\"VBA\",\"xlSheetHidden\",\"xlSheetVeryHidden\",\"xlSheetVisible\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/\",\"name\":\"Hojas ocultas y visibles en excel: visible, oculta y muy oculta. - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/no-face-1563267-1280x960-1.jpg\",\"datePublished\":\"2018-01-24T06:35:29+00:00\",\"dateModified\":\"2023-10-27T19:18:08+00:00\",\"description\":\"ver hojas ocultas excel, hoja oculta y muy oculta. Todas las modalidades que Excel tiene dsponibles, c\u00f3mo ejecutarlas y descarga el ejemplo.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/no-face-1563267-1280x960-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/no-face-1563267-1280x960-1.jpg\",\"width\":1280,\"height\":960},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hojas ocultas y visibles en excel: visible, oculta y muy oculta.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"contentUrl\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/excelyfinanzasmx\\\/\",\"https:\\\/\\\/x.com\\\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hojas ocultas y visibles en excel: visible, oculta y muy oculta. - Business Intelligence MX","description":"ver hojas ocultas excel, hoja oculta y muy oculta. Todas las modalidades que Excel tiene dsponibles, c\u00f3mo ejecutarlas y descarga el ejemplo.","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:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/","og_locale":"en_US","og_type":"article","og_title":"Descubre esta s\u00faper caracter\u00edstica de Excel","og_description":"ver hojas ocultas excel, hoja oculta y muy oculta. Todas las modalidades que Excel tiene dsponibles, c\u00f3mo ejecutarlas y descarga el ejemplo.","og_url":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-01-24T06:35:29+00:00","article_modified_time":"2023-10-27T19:18:08+00:00","og_image":[{"width":1280,"height":960,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/no-face-1563267-1280x960-1.jpg","type":"image\/jpeg"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_title":"Descubre esta s\u00faper caracter\u00edstica de Excel","twitter_image":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/no-face-1563267-1280x960-1.jpg","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"Hojas ocultas y visibles en excel: visible, oculta y muy oculta.","datePublished":"2018-01-24T06:35:29+00:00","dateModified":"2023-10-27T19:18:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/"},"wordCount":731,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/no-face-1563267-1280x960-1.jpg","keywords":["Excel","Macros","VBA","xlSheetHidden","xlSheetVeryHidden","xlSheetVisible"],"articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/","url":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/","name":"Hojas ocultas y visibles en excel: visible, oculta y muy oculta. - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/no-face-1563267-1280x960-1.jpg","datePublished":"2018-01-24T06:35:29+00:00","dateModified":"2023-10-27T19:18:08+00:00","description":"ver hojas ocultas excel, hoja oculta y muy oculta. Todas las modalidades que Excel tiene dsponibles, c\u00f3mo ejecutarlas y descarga el ejemplo.","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/no-face-1563267-1280x960-1.jpg","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/no-face-1563267-1280x960-1.jpg","width":1280,"height":960},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/excel\/hojas-ocultas-y-visibles-en-excel-visible-oculta-y-muy-oculta\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"Hojas ocultas y visibles en excel: visible, oculta y muy oculta."}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=391"}],"version-history":[{"count":16,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/391\/revisions"}],"predecessor-version":[{"id":20842,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/391\/revisions\/20842"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/3833"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}