{"id":131,"date":"2012-07-16T17:53:00","date_gmt":"2012-07-16T17:53:00","guid":{"rendered":"https:\/\/sigocontando.com\/?p=131"},"modified":"2012-07-16T17:53:00","modified_gmt":"2012-07-16T17:53:00","slug":"desproteger-hoja-calculo","status":"publish","type":"post","link":"http:\/\/www.sigocontando.com\/?p=131","title":{"rendered":"Desproteger hoja calculo"},"content":{"rendered":"<div style=\"clear: both; text-align: center;\"><a href=\"http:\/\/4.bp.blogspot.com\/-Rai5vCdTfJU\/UARVHQe8VpI\/AAAAAAAAAts\/GgnFjiOgZaM\/s1600\/foto_candado.jpg\" style=\"margin-left: 1em; margin-right: 1em;\"><img decoding=\"async\" loading=\"lazy\" border=\"0\" ca=\"true\" height=\"290\" src=\"http:\/\/4.bp.blogspot.com\/-Rai5vCdTfJU\/UARVHQe8VpI\/AAAAAAAAAts\/GgnFjiOgZaM\/s320\/foto_candado.jpg\" width=\"320\" \/><\/a><\/div>\n<p>\u00bfCuantas veces se nos olvida la clave que pusimos aun archivo y pensamos que ya lo perdimos? Bueno aqui los pasos para desbloquear el archivo en excel<\/p>\n<p>Primer paso<br \/>Se va a crear una nueva macro y se va a poner lo siguiente:<br \/><a name='more'><\/a><br \/><span style=\"color: red;\">Sub breakit() <\/span><br \/><span style=\"color: red;\"><\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Dim i As Integer, j As Integer, k As Integer <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Dim l As Integer, m As Integer, n As Integer <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">On Error Resume Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For i = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For j = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For k = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For l = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For m = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For i1 = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For i2 = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For i3 = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For i4 = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For i5 = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For i6 = 65 To 66 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">For n = 32 To 126 <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">ActiveSheet.Unprotect Chr(i) &amp; Chr(j) &amp; Chr(k) &amp; Chr(l) &amp; Chr(m) &amp; Chr(i1) &amp; Chr(i2) &amp; Chr(i3) &amp; Chr(i4) &amp; Chr(i5) &amp; Chr(i6) &amp; Chr(n) <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">If ActiveSheet.ProtectContents = False Then <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">MsgBox &#8220;One usable password is &#8221; &amp; Chr(i) &amp; Chr(j) &amp; Chr(k) &amp; Chr(l) &amp; Chr(m) &amp; Chr(i1) &amp; Chr(i2) &amp; Chr(i3) &amp; Chr(i4) &amp; Chr(i5) &amp; Chr(i6) &amp; Chr(n) <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Exit Sub <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">End If <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">Next <\/span><br \/><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\"><br \/><\/span><span style=\"color: red;\">End Sub <\/span><\/p>\n<p><span style=\"color: red;\"><u><span style=\"color: black;\">Copian y pegan en un modulo de visual del excel y luego dentro del libro a desproteger le dan ALT + F8 y eligen la macro y la ejecutan, esperan unos segundos y listo<\/span><\/u><\/span><\/p>\n<p><span style=\"color: red;\"><span style=\"color: black;\">Es todo lo que hacemos&#8230; espero comentarios<\/span><\/span><\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfCuantas veces se nos olvida la clave que pusimos aun archivo y pensamos que ya lo perdimos? Bueno aqui los pasos para desbloquear el archivo en excel Primer pasoSe va &hellip; <a href=\"http:\/\/www.sigocontando.com\/?p=131\" class=\"more-link\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[90,91,64],"tags":[],"_links":{"self":[{"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=\/wp\/v2\/posts\/131"}],"collection":[{"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131"}],"version-history":[{"count":0,"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sigocontando.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}