{"id":1037,"date":"2017-01-03T19:35:42","date_gmt":"2017-01-04T01:35:42","guid":{"rendered":"https:\/\/emanuelpaxtian.com\/blog\/?p=1037"},"modified":"2017-01-03T19:36:30","modified_gmt":"2017-01-04T01:36:30","slug":"desproteger-hoja-de-excel","status":"publish","type":"post","link":"https:\/\/emanuelpaxtian.com\/blog\/desproteger-hoja-de-excel\/","title":{"rendered":"Desproteger hoja de Excel"},"content":{"rendered":"<p>En ocasiones estamos trabajando con documentos creados en Excel y necesitamos editar ciertas partes pero nos encontramos que el libro esta protegido con contrase\u00f1a la cual no sabemos existe una forma para desbloquear el documento utilizando Macros para ello utilizamos el siguiente metodo<\/p>\n<ul>\n<li>Presiona ALT + F8 para que te da la pantallita de crear una macro y el nombre del macro y pones un nombre y le das en crear<\/li>\n<li>Cuando le des CREAR te lleva al editor de Visual Basic, ahi copiaremos el c\u00f3digo que esta a continuaci\u00f3n<\/li>\n<li>Le damos en ejecutar y esperamos que nos salga una ventana de alerta con unas letras esa es la clave que tenemos que usar<\/li>\n<li>Luego nos vamos a desproteger hoja y pegamos la clave y listo<\/li>\n<\/ul>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\nSub breakit() \r\n\r\nDim i As Integer, j As Integer, k As Integer \r\nDim l As Integer, m As Integer, n As Integer \r\nOn Error Resume Next \r\nFor i = 65 To 66 \r\nFor j = 65 To 66 \r\nFor k = 65 To 66 \r\nFor l = 65 To 66 \r\nFor m = 65 To 66 \r\nFor i1 = 65 To 66 \r\nFor i2 = 65 To 66 \r\nFor i3 = 65 To 66 \r\nFor i4 = 65 To 66 \r\nFor i5 = 65 To 66 \r\nFor i6 = 65 To 66 \r\nFor n = 32 To 126 \r\nActiveSheet.Unprotect Chr(i) &amp; Chr(j) &amp; Chr(k) &amp; _ \r\nChr(l) &amp; Chr(m) &amp; Chr(i1) &amp; Chr(i2) &amp; Chr(i3) &amp; _ \r\nChr(i4) &amp; Chr(i5) &amp; Chr(i6) &amp; Chr(n) \r\nIf ActiveSheet.ProtectContents = False Then \r\nMsgBox &quot;One usable password is &quot; &amp; Chr(i) &amp; Chr(j) &amp; _ \r\nChr(k) &amp; Chr(l) &amp; Chr(m) &amp; Chr(i1) &amp; Chr(i2) &amp; Chr(i3) _ \r\n&amp; Chr(i4) &amp; Chr(i5) &amp; Chr(i6) &amp; Chr(n) \r\nExit Sub \r\nEnd If \r\nNext \r\nNext \r\nNext \r\nNext \r\nNext \r\nNext \r\nNext \r\nNext \r\nNext \r\nNext \r\nNext \r\nNext \r\n\r\nEnd Sub \r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>En ocasiones estamos trabajando con documentos creados en Excel y necesitamos editar ciertas partes pero nos encontramos que el libro esta protegido con contrase\u00f1a la cual no sabemos existe una&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1038,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,10,15],"tags":[],"class_list":["post-1037","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","category-seguridad","category-windows"],"_links":{"self":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts\/1037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/comments?post=1037"}],"version-history":[{"count":0,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts\/1037\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/media\/1038"}],"wp:attachment":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/media?parent=1037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/categories?post=1037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/tags?post=1037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}