{"id":312,"date":"2020-06-28T01:16:41","date_gmt":"2020-06-28T01:16:41","guid":{"rendered":"https:\/\/www.infracounter.com\/weblog\/?p=312"},"modified":"2020-07-18T02:28:54","modified_gmt":"2020-07-18T02:28:54","slug":"proteger-celdas-archivos-excel","status":"publish","type":"post","link":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/","title":{"rendered":"4. Formas de proteger los datos y archivos – Parte 1"},"content":{"rendered":"[vc_row][vc_column][vc_column_text]Tiempo estimado de lectura 1 minuto.<\/span><\/strong><\/p>\n

Sabemos lo inquietante que es ver como nuestros formatos han sido manipulados de la forma no correcta ya sea por causa de la persona a quien encargamos, tal vez por alguien que nos quiera perjudicar o posiblemente nosotros sin darnos cuenta. Esta herramienta nos permite restringir una serie de campos que evitar\u00e1 que se ocasionen accidentes, facilitar la vida y el uso adecuado<\/span>.<\/span><\/p>\n

Al ser bloqueados esos campos espec\u00edficos podr\u00e1 ser modificado por el usuario quien tiene el acceso a las contrase\u00f1as, no queremos m\u00e1rgenes de errores (como los que podemos visualizar en el cap\u00edtulo 1. Tipos de errores m\u00e1s comunes y como solucionarlos<\/strong><\/a><\/em>) donde otros usuarios cambien, muevan o eliminen datos de las hojas de c\u00e1lculos y da\u00f1e todo el proceso de ejecuci\u00f3n sin previo aviso.<\/span><\/p>\n[\/vc_column_text][vc_empty_space][vc_column_text]ESTA HERRAMIENTA NOS PERMITE PROTEGER LOS SIGUIENTES CAMPOS:<\/span><\/strong><\/p>\n

    \n
  1. Celdas<\/span><\/li>\n
  2. Hoja o Etiqueta<\/span><\/li>\n
  3. Libro o Archivo<\/span><\/li>\n
  4. Compartir libro<\/span><\/li>\n
  5. Apertura del archivo<\/span><\/li>\n
  6. VBA<\/span><\/li>\n<\/ol>\n[\/vc_column_text][vc_empty_space][vc_column_text]\n

    En las siguientes gr\u00e1ficas podemos determinar c\u00f3mo es la visualizaci\u00f3n para efectuar los respectivos bloqueos de nuestros formatos<\/span>.<\/span><\/p>\n

    En la primera imagen podemos encontrar como proteger los campos en la cinta de opciones (Explora m\u00e1s el cap\u00edtulo 2. Estructura de la venta principal<\/a><\/strong><\/em>).<\/span><\/p>\n[\/vc_column_text][vc_empty_space][vc_single_image image=\u00bb314″][vc_empty_space][vc_column_text]\n

    En la segunda y tercer gr\u00e1fica obtenemos la visualizaci\u00f3n del bloqueo de apertura del archivo y del controlador de desarrollo de Visual Basic<\/span>.<\/span><\/p>\n[\/vc_column_text][vc_empty_space][vc_single_image image=\u00bb315″ alignment=\u00bbcenter\u00bb][vc_empty_space][vc_single_image image=\u00bb316″ alignment=\u00bbcenter\u00bb][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"

    [vc_row][vc_column][vc_column_text]Tiempo estimado de lectura 1 minuto. Sabemos lo inquietante que es ver como nuestros formatos han sido manipulados de la forma no correcta ya sea por causa de la persona a quien encargamos, tal vez por alguien que nos quiera perjudicar o posiblemente nosotros sin darnos cuenta. Esta herramienta nos permite restringir una serie de…<\/p>\n","protected":false},"author":1,"featured_media":365,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6,1],"tags":[],"post_series":[],"yoast_head":"\n4. Formas de proteger los datos y archivos - Parte 1 Excel fac\u00edl y seguros (Celdas)<\/title>\n<meta name=\"description\" content=\"Bloquea y ayuda a proteger tus celdas y archivos de Excel, gestiona la seguridad para evitar futuros errores o da\u00f1os y no tener que lamentarte luego\" \/>\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.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"4. Formas de proteger los datos y archivos - Parte 1 Excel fac\u00edl y seguros (Celdas)\" \/>\n<meta property=\"og:description\" content=\"Bloquea y ayuda a proteger tus celdas y archivos de Excel, gestiona la seguridad para evitar futuros errores o da\u00f1os y no tener que lamentarte luego\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Weblog\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-28T01:16:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-18T02:28:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1288\" \/>\n\t<meta property=\"og:image:height\" content=\"785\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"infrac_userDbAmin10101\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"infrac_userDbAmin10101\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/\"},\"author\":{\"name\":\"infrac_userDbAmin10101\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#\/schema\/person\/dcd6120bdf23f0ec9c8cfa9a84589091\"},\"headline\":\"4. Formas de proteger los datos y archivos – Parte 1\",\"datePublished\":\"2020-06-28T01:16:41+00:00\",\"dateModified\":\"2020-07-18T02:28:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/\"},\"wordCount\":307,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg\",\"articleSection\":[\"Principiante\",\"Tips\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/\",\"url\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/\",\"name\":\"4. Formas de proteger los datos y archivos - Parte 1 Excel fac\u00edl y seguros (Celdas)\",\"isPartOf\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg\",\"datePublished\":\"2020-06-28T01:16:41+00:00\",\"dateModified\":\"2020-07-18T02:28:54+00:00\",\"description\":\"Bloquea y ayuda a proteger tus celdas y archivos de Excel, gestiona la seguridad para evitar futuros errores o da\u00f1os y no tener que lamentarte luego\",\"breadcrumb\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#primaryimage\",\"url\":\"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg\",\"contentUrl\":\"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg\",\"width\":1288,\"height\":785},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.infracounter.com\/weblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"4. Formas de proteger los datos y archivos – Parte 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#website\",\"url\":\"https:\/\/www.infracounter.com\/weblog\/\",\"name\":\"Weblog\",\"description\":\"Otro sitio m\u00e1s de Infracounter sitios\",\"publisher\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.infracounter.com\/weblog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#organization\",\"name\":\"Weblog\",\"url\":\"https:\/\/www.infracounter.com\/weblog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/05\/blog-excel-03.png\",\"contentUrl\":\"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/05\/blog-excel-03.png\",\"width\":2725,\"height\":1262,\"caption\":\"Weblog\"},\"image\":{\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#\/schema\/person\/dcd6120bdf23f0ec9c8cfa9a84589091\",\"name\":\"infrac_userDbAmin10101\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.infracounter.com\/weblog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6d1a2b5a2680c08b71ff7fd2dbd6fa21?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6d1a2b5a2680c08b71ff7fd2dbd6fa21?s=96&d=mm&r=g\",\"caption\":\"infrac_userDbAmin10101\"},\"sameAs\":[\"https:\/\/www.infracounter.com\"],\"url\":\"https:\/\/www.infracounter.com\/weblog\/author\/infrac_userdbamin10101\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"4. Formas de proteger los datos y archivos - Parte 1 Excel fac\u00edl y seguros (Celdas)","description":"Bloquea y ayuda a proteger tus celdas y archivos de Excel, gestiona la seguridad para evitar futuros errores o da\u00f1os y no tener que lamentarte luego","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.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/","og_locale":"es_ES","og_type":"article","og_title":"4. Formas de proteger los datos y archivos - Parte 1 Excel fac\u00edl y seguros (Celdas)","og_description":"Bloquea y ayuda a proteger tus celdas y archivos de Excel, gestiona la seguridad para evitar futuros errores o da\u00f1os y no tener que lamentarte luego","og_url":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/","og_site_name":"Weblog","article_published_time":"2020-06-28T01:16:41+00:00","article_modified_time":"2020-07-18T02:28:54+00:00","og_image":[{"width":1288,"height":785,"url":"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg","type":"image\/jpeg"}],"author":"infrac_userDbAmin10101","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"infrac_userDbAmin10101","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#article","isPartOf":{"@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/"},"author":{"name":"infrac_userDbAmin10101","@id":"https:\/\/www.infracounter.com\/weblog\/#\/schema\/person\/dcd6120bdf23f0ec9c8cfa9a84589091"},"headline":"4. Formas de proteger los datos y archivos – Parte 1","datePublished":"2020-06-28T01:16:41+00:00","dateModified":"2020-07-18T02:28:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/"},"wordCount":307,"commentCount":0,"publisher":{"@id":"https:\/\/www.infracounter.com\/weblog\/#organization"},"image":{"@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg","articleSection":["Principiante","Tips"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/","url":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/","name":"4. Formas de proteger los datos y archivos - Parte 1 Excel fac\u00edl y seguros (Celdas)","isPartOf":{"@id":"https:\/\/www.infracounter.com\/weblog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg","datePublished":"2020-06-28T01:16:41+00:00","dateModified":"2020-07-18T02:28:54+00:00","description":"Bloquea y ayuda a proteger tus celdas y archivos de Excel, gestiona la seguridad para evitar futuros errores o da\u00f1os y no tener que lamentarte luego","breadcrumb":{"@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#primaryimage","url":"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg","contentUrl":"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/06\/Proteger-Restringir.jpg","width":1288,"height":785},{"@type":"BreadcrumbList","@id":"https:\/\/www.infracounter.com\/weblog\/proteger-celdas-archivos-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.infracounter.com\/weblog\/"},{"@type":"ListItem","position":2,"name":"4. Formas de proteger los datos y archivos – Parte 1"}]},{"@type":"WebSite","@id":"https:\/\/www.infracounter.com\/weblog\/#website","url":"https:\/\/www.infracounter.com\/weblog\/","name":"Weblog","description":"Otro sitio m\u00e1s de Infracounter sitios","publisher":{"@id":"https:\/\/www.infracounter.com\/weblog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.infracounter.com\/weblog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.infracounter.com\/weblog\/#organization","name":"Weblog","url":"https:\/\/www.infracounter.com\/weblog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.infracounter.com\/weblog\/#\/schema\/logo\/image\/","url":"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/05\/blog-excel-03.png","contentUrl":"https:\/\/www.infracounter.com\/weblog\/wp-content\/uploads\/sites\/6\/2020\/05\/blog-excel-03.png","width":2725,"height":1262,"caption":"Weblog"},"image":{"@id":"https:\/\/www.infracounter.com\/weblog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.infracounter.com\/weblog\/#\/schema\/person\/dcd6120bdf23f0ec9c8cfa9a84589091","name":"infrac_userDbAmin10101","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.infracounter.com\/weblog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d1a2b5a2680c08b71ff7fd2dbd6fa21?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d1a2b5a2680c08b71ff7fd2dbd6fa21?s=96&d=mm&r=g","caption":"infrac_userDbAmin10101"},"sameAs":["https:\/\/www.infracounter.com"],"url":"https:\/\/www.infracounter.com\/weblog\/author\/infrac_userdbamin10101\/"}]}},"_links":{"self":[{"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/posts\/312"}],"collection":[{"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/comments?post=312"}],"version-history":[{"count":8,"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":333,"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/posts\/312\/revisions\/333"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/media\/365"}],"wp:attachment":[{"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/media?parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/categories?post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/tags?post=312"},{"taxonomy":"post_series","embeddable":true,"href":"https:\/\/www.infracounter.com\/weblog\/wp-json\/wp\/v2\/post_series?post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}