{"id":1348,"date":"2018-05-16T08:24:36","date_gmt":"2018-05-16T05:24:36","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1348"},"modified":"2018-05-16T08:24:36","modified_gmt":"2018-05-16T05:24:36","slug":"excelde-sayfa-korumasi-sifresini-cozme","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/excelde-sayfa-korumasi-sifresini-cozme\/","title":{"rendered":"Excelde Sayfa Korumas\u0131 \u015eifresini \u00c7\u00f6zme"},"content":{"rendered":"<p><a href=\"https:\/\/burakcaliskan.org\/blog\/depo\/2018\/05\/excel-tablo-koruma.png\"><img loading=\"lazy\" class=\"alignnone size-medium wp-image-1349\" src=\"https:\/\/burakcaliskan.org\/blog\/depo\/2018\/05\/excel-tablo-koruma-300x149.png\" alt=\"\" width=\"300\" height=\"149\" srcset=\"https:\/\/burakcaliskan.org\/blog\/depo\/2018\/05\/excel-tablo-koruma-300x149.png 300w, https:\/\/burakcaliskan.org\/blog\/depo\/2018\/05\/excel-tablo-koruma.png 640w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Excelde sayfa korumas\u0131n\u0131 kald\u0131rmak ve \u015fifreyi k\u0131rmak i\u00e7in \u015fu ad\u0131mlar\u0131 izlememiz yeterli olacakt\u0131r.<\/p>\n<p><strong>1)<\/strong>\u00a0 Excel dosyas\u0131nda korumal\u0131 sayfa a\u00e7\u0131kken klavyeden\u00a0<strong>alt<\/strong>\u00a0ve\u00a0<strong>F11<\/strong>\u00a0tu\u015flar\u0131na bas\u0131n.<span id=\"more-1185\"><\/span><\/p>\n<p><strong>2)\u00a0<\/strong>\u00a0A\u00e7\u0131lan pencereden\u00a0<strong>insert<\/strong>\u00a0men\u00fcs\u00fcnden\u00a0<strong>mod\u00fcl<\/strong>\u00a0e t\u0131klay\u0131n.<\/p>\n<p><strong>3)<\/strong>\u00a0A\u00e7\u0131lan kod penceresine a\u015fa\u011f\u0131daki kodu kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n.<\/p>\n<pre class=\"lang:default decode:true \">Sub SifreAc()\r\nDim i As Integer, j As Integer, k As Integer\r\nDim l As Integer, m As Integer, n As Integer\r\nDim i1 As Integer, i2 As Integer, i3 As Integer\r\nDim i4 As Integer, i5 As Integer, i6 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) _\r\n&amp; Chr(i4) &amp; Chr(i5) &amp; Chr(i6) &amp; Chr(n)\r\nIf ActiveSheet.ProtectContents = False Then\r\nMsgBox \"One usable password is \" &amp; Chr(i) &amp; Chr(j) _\r\n&amp; Chr(k) &amp; Chr(l) &amp; Chr(m) &amp; Chr(i1) &amp; Chr(i2) _\r\n&amp; Chr(i3) &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\nEnd Sub<\/pre>\n<p><strong>4)<\/strong>\u00a0<strong>Run<\/strong>\u00a0men\u00fcs\u00fcnden\u00a0<strong>run<\/strong>\u00a0a t\u0131klay\u0131n veya F5. Bilgisayar yap\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131z kodlarla korumay\u0131 kald\u0131rmaya yani \u015fifreye k\u0131rmay\u0131 deneyecektir. Biraz bekleyin.<\/p>\n<p><a href=\"https:\/\/burakcaliskan.org\/blog\/depo\/2018\/05\/exceltamam.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1350\" src=\"https:\/\/burakcaliskan.org\/blog\/depo\/2018\/05\/exceltamam.jpg\" alt=\"\" width=\"284\" height=\"152\" \/><\/a><\/p>\n<p><strong>5)<\/strong>\u00a0Yukar\u0131daki gibi bir pencere geldi\u011finde\u00a0<strong>Tamam<\/strong>\u00a0butonuna t\u0131klay\u0131n. Sayfa korumas\u0131 art\u0131k kalkm\u0131\u015f olacak ve sayfada istedi\u011finiz de\u011fi\u015fikli\u011fi yapabilirsiniz.<\/p>\n<p><strong>Not: E<\/strong>xcel dosyas\u0131ndaki her sayfa i\u00e7in ayr\u0131 ayr\u0131 uygulaman\u0131z gerekmektedir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excelde sayfa korumas\u0131n\u0131 kald\u0131rmak ve \u015fifreyi k\u0131rmak i\u00e7in \u015fu ad\u0131mlar\u0131 izlememiz yeterli olacakt\u0131r. 1)\u00a0 Excel dosyas\u0131nda korumal\u0131 sayfa a\u00e7\u0131kken klavyeden\u00a0alt\u00a0ve\u00a0F11\u00a0tu\u015flar\u0131na bas\u0131n. 2)\u00a0\u00a0A\u00e7\u0131lan pencereden\u00a0insert\u00a0men\u00fcs\u00fcnden\u00a0mod\u00fcl\u00a0e t\u0131klay\u0131n. 3)\u00a0A\u00e7\u0131lan kod penceresine a\u015fa\u011f\u0131daki kodu kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n. Sub SifreAc() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21,20],"tags":[],"_links":{"self":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1348"}],"collection":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/comments?post=1348"}],"version-history":[{"count":1,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1348\/revisions"}],"predecessor-version":[{"id":1351,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1348\/revisions\/1351"}],"wp:attachment":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media?parent=1348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}