{"id":46,"date":"2018-01-09T01:21:58","date_gmt":"2018-01-09T01:21:58","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=46"},"modified":"2023-10-27T19:18:41","modified_gmt":"2023-10-27T19:18:41","slug":"la-hoja-de-excel-escondida-con-un-password","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/","title":{"rendered":"Ocultar hoja de Excel con contrase\u00f1a"},"content":{"rendered":"<h2>Hoja muy oculta en Excel<\/h2>\n<p><!-- RegularPostHeader --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: inline-block; width: 728px; height: 90px;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4391345816\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<p>Quieres proteger solo una parte del libro de trabajo, y no quieres que haya rastro del mismo. Descarga el archivo (<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\" href=\"https:\/\/www.fditf.com\/bi\/download\/1998\/?tmstv=1785037093\" rel=\"nofollow\" id=\"download-link-1998\" data-redirect=\"false\" >\n\thoja_oculta<\/a>\n). Y esta es la explicaci\u00f3n&#8230;<\/p>\n<h2>C\u00f3mo ver una hoja oculta en Excel<\/h2>\n<p>Paso 0. Abrir el archivo.<\/p>\n<p>Paso 1. Trata de ver las hojas ocultas. Notar\u00e1s que en apariencia no hay ninguna.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1978 size-medium\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img01-1-300x187.png\" alt=\"\" width=\"300\" height=\"187\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img01-1-300x187.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img01-1-768x478.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img01-1.png 998w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Paso 2. Usa los botones de arriba (&#8220;<span style=\"color: #ff0000;\"><strong>ver hoja oculta<\/strong><\/span>&#8221; y &#8220;<span style=\"color: #ff0000;\"><strong>ver hoja oculta (con password)<\/strong><\/span>&#8220;). Verificar\u00e1s que efectivamente hay dos hojas m\u00e1s en el libro.<\/p>\n<ul>\n<li>Click en el bot\u00f3n &#8220;Ver hoja oculta&#8221;<\/li>\n<\/ul>\n<p>&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1979\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img02-1.png\" alt=\"\" width=\"359\" height=\"175\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img02-1.png 359w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img02-1-300x146.png 300w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><\/p>\n<ul>\n<li>Aparecer\u00e1 una hoja (con el nombre &#8220;HojaOculta&#8221; y sombreada en rojo). Para esconderla de nuevo, usa el bot\u00f3n &#8220;Esconder hoja&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1980\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img03.png\" alt=\"\" width=\"364\" height=\"199\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img03.png 364w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img03-300x164.png 300w\" sizes=\"auto, (max-width: 364px) 100vw, 364px\" \/><\/p>\n<ul>\n<li>Ahora intenta con el bot\u00f3n &#8220;Ver hoja oculta (con password)&#8221;. Aparece una ventana. Escribe el password: <strong>hola<\/strong>.<\/li>\n<\/ul>\n<p>&#8211;<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1991\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/nueva_ver.png\" alt=\"\" width=\"703\" height=\"186\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/nueva_ver.png 703w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/nueva_ver-300x79.png 300w\" sizes=\"auto, (max-width: 703px) 100vw, 703px\" \/><\/p>\n<ul>\n<li>Aparecer\u00e1 una nueva hoja! Para esconderla de nuevo, usa el bot\u00f3n &#8220;Esconder hoja&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1982\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img05.png\" alt=\"\" width=\"462\" height=\"217\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img05.png 462w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/img05-300x141.png 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- RegularPostBottom --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"2196072090\" data-ad-format=\"auto\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>C\u00f3mo esconder una hoja con un password<\/h2>\n<p>Las macros son muy simples: modifican la propiedad &#8220;visible&#8221; para una hoja determinada. Esta propiedad puede tomar tres valore: i) -1, es el valor por default para todas las hojas, todas son visibles al crearse; ii) 0, es el valor que toma eta propiedad cuando ocultas una hoja con el proceso ordinario: click derecho y ocultar; iii) 2, es el valor que toman las hojas cuando no quieres que queden accesibles para nadie; solo notar\u00e1s que esta hoja existe si accedes al c\u00f3digo en VBA (mismo que puedes proteger con un password). Con este \u00faltimo valor, solo un usuario experimentado podr\u00eda encontrar tal hoja. Y ocurre lo mismo para la asignaci\u00f3n de este valor: solo lo puedes asignar por medio de c\u00f3digo (macros).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1994\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/visible.png\" alt=\"\" width=\"312\" height=\"271\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/visible.png 312w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/visible-300x261.png 300w\" sizes=\"auto, (max-width: 312px) 100vw, 312px\" \/><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><br \/>\nEl c\u00f3digo que hace el trabajo es este (este es el c\u00f3digo para el bot\u00f3n &#8220;ver hoja oculta&#8221;):<\/p>\n<p><strong><span style=\"color: #0000ff;\">Private Sub<\/span> CommandButton1_Click()<\/strong><br \/>\n<span style=\"color: #ff6600;\"><strong>Sheet2.Visible = -1<\/strong><\/span><br \/>\n<strong>Sheet2.Activate<\/strong><br \/>\n<strong>ActiveSheet.Range(&#8220;A1&#8221;).Activate<\/strong><br \/>\n<strong><span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/p>\n<p>La l\u00ednea en naranja es la que cambia el valor de la propiedad &#8220;visible&#8221; de una hoja determinada (en este caso,la hoja 2). La pone en el valor <span style=\"color: #ff0000;\">-1<\/span>, que es el correspondiente a las hojas visibles. Ocurre lo mismo con la macro que pide un password, solo que esta macro hace una validaci\u00f3n del password antes de proceder al cambio:<\/p>\n<ul>\n<li>Primero se muestra el formulario (que contiene la caja de texto para ingresar el password):<\/li>\n<\/ul>\n<p><strong><span style=\"color: #0000ff;\">Private Sub<\/span> CommandButton2_Click()<\/strong><br \/>\n<strong>AccessControl.Show<\/strong><br \/>\n<span style=\"color: #0000ff;\"><strong>End Sub<\/strong><\/span><\/p>\n<ul>\n<li>Al ingresar el password, se valida. Si es correcto, se cambia la propiedad &#8220;visible&#8221; de la hoja determinada (en este caso, la hoja 3).<\/li>\n<\/ul>\n<p><strong><span style=\"color: #0000ff;\">Private Sub<\/span> CommandButton1_Click()<\/strong><br \/>\n<strong><span style=\"color: #0000ff;\">If<\/span> TextBox1 = &#8220;hola&#8221; <span style=\"color: #0000ff;\">Then<\/span><\/strong><br \/>\n<strong>Sheet3.Visible = -1<\/strong><br \/>\n<strong>Sheet3.Activate<\/strong><br \/>\n<strong>Range(&#8220;A11&#8221;).Select<\/strong><br \/>\n<span style=\"color: #0000ff;\"><strong>Else<\/strong><\/span><br \/>\n<strong>MsgBox &#8220;Acceso solo con password!&#8221;, vbCritical, &#8220;Verifica tu password &#8211; FDITF.com&#8221;<\/strong><br \/>\n<span style=\"color: #0000ff;\"><strong>End If<\/strong><\/span><br \/>\n<strong>AccessControl.Hide<\/strong><br \/>\n<span style=\"color: #0000ff;\"><strong>End Sub<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- post_edate --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4902726138\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoja muy oculta en Excel Quieres proteger solo una parte del libro de trabajo, y no quieres que haya rastro del mismo. Descarga el archivo (). Y esta es la explicaci\u00f3n&#8230; C\u00f3mo ver una hoja oculta en Excel Paso 0. <a href=\"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":3888,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,117],"tags":[7,9,8,21],"class_list":["post-46","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-vba","tag-excel","tag-forms","tag-macros","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Ocultar hoja de Excel con contrase\u00f1a - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"Ocultar hoja de Excel con contrase\u00f1a usando la opci\u00f3n de Excel very hidden. Descarga el ejemplo listo para usarse.\" \/>\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\/la-hoja-de-excel-escondida-con-un-password\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ocultar hoja de Excel con contrase\u00f1a - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"Ocultar hoja de Excel con contrase\u00f1a usando la opci\u00f3n de Excel very hidden. Descarga el ejemplo listo para usarse.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/\" \/>\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-09T01:21:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T19:18:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/man-1461448_1280.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"852\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\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: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=\"4 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\\\/la-hoja-de-excel-escondida-con-un-password\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"Ocultar hoja de Excel con contrase\u00f1a\",\"datePublished\":\"2018-01-09T01:21:58+00:00\",\"dateModified\":\"2023-10-27T19:18:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/\"},\"wordCount\":473,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/man-1461448_1280.jpg\",\"keywords\":[\"Excel\",\"Forms\",\"Macros\",\"VBA\"],\"articleSection\":[\"Excel\",\"VBA\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/\",\"name\":\"Ocultar hoja de Excel con contrase\u00f1a - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/man-1461448_1280.jpg\",\"datePublished\":\"2018-01-09T01:21:58+00:00\",\"dateModified\":\"2023-10-27T19:18:41+00:00\",\"description\":\"Ocultar hoja de Excel con contrase\u00f1a usando la opci\u00f3n de Excel very hidden. Descarga el ejemplo listo para usarse.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/man-1461448_1280.jpg\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/man-1461448_1280.jpg\",\"width\":852,\"height\":1280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-hoja-de-excel-escondida-con-un-password\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ocultar hoja de Excel con contrase\u00f1a\"}]},{\"@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":"Ocultar hoja de Excel con contrase\u00f1a - Business Intelligence MX","description":"Ocultar hoja de Excel con contrase\u00f1a usando la opci\u00f3n de Excel very hidden. Descarga el ejemplo listo para usarse.","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\/la-hoja-de-excel-escondida-con-un-password\/","og_locale":"en_US","og_type":"article","og_title":"Ocultar hoja de Excel con contrase\u00f1a - Business Intelligence MX","og_description":"Ocultar hoja de Excel con contrase\u00f1a usando la opci\u00f3n de Excel very hidden. Descarga el ejemplo listo para usarse.","og_url":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-01-09T01:21:58+00:00","article_modified_time":"2023-10-27T19:18:41+00:00","og_image":[{"width":852,"height":1280,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/man-1461448_1280.jpg","type":"image\/jpeg"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"Ocultar hoja de Excel con contrase\u00f1a","datePublished":"2018-01-09T01:21:58+00:00","dateModified":"2023-10-27T19:18:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/"},"wordCount":473,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/man-1461448_1280.jpg","keywords":["Excel","Forms","Macros","VBA"],"articleSection":["Excel","VBA"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/","url":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/","name":"Ocultar hoja de Excel con contrase\u00f1a - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/man-1461448_1280.jpg","datePublished":"2018-01-09T01:21:58+00:00","dateModified":"2023-10-27T19:18:41+00:00","description":"Ocultar hoja de Excel con contrase\u00f1a usando la opci\u00f3n de Excel very hidden. Descarga el ejemplo listo para usarse.","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/man-1461448_1280.jpg","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/man-1461448_1280.jpg","width":852,"height":1280},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/excel\/la-hoja-de-excel-escondida-con-un-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"Ocultar hoja de Excel con contrase\u00f1a"}]},{"@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\/46","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=46"}],"version-history":[{"count":22,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/46\/revisions"}],"predecessor-version":[{"id":5386,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/46\/revisions\/5386"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/3888"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}