{"id":162,"date":"2014-03-14T03:25:00","date_gmt":"2014-03-13T20:25:00","guid":{"rendered":"https:\/\/blog.pcc.web.id\/?p=162"},"modified":"2020-04-28T23:43:20","modified_gmt":"2020-04-28T16:43:20","slug":"how-to-unprotect-microsoft-excel-sheet-without-password","status":"publish","type":"post","link":"https:\/\/agusarmanto.com\/en\/how-to-unprotect-microsoft-excel-sheet-without-password","title":{"rendered":"How to Unprotect Microsoft Excel Sheet without Password"},"content":{"rendered":"
\n
This morning, a colleague came with an excel file that could not be edited, because the sheet was protected by its creator. My friend asked to unprotect the Microsoft Excel sheet, because he didn't know the password. When trying to edit it, a warning will appear like this.<\/div>\n\n\n\n\n
\"protectsheet-6320984\"<\/a><\/figure><\/figure><\/figure><\/td>\n<\/tr>\n
\"the cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove the protection using the Unprotect Sheet command (Review tab, Change group). You may be prompted for a password\"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 <\/div>\n

<\/a><\/p>\n

or another characteristic of a protected sheet is if we look at the tab review<\/i><\/b> then there will be an icon unprotect Sheet <\/b><\/i><\/div>\n\n\n\n\n
\"unprotectsheet-2453568\"<\/a><\/figure><\/figure><\/figure><\/td>\n<\/tr>\n
Unprotect Sheet Icon<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
The file can only be edited if we know the password for the Unprotect Sheet. <\/i>I just realized that I haven't played around with protected Excel sheets for years :D. In the past, I usually used Open Office to edit protected files, from the experiment, it turns out that excel protection does not apply in other programs such as Open Office, Libre Office, etc. <\/div>\n
 <\/div>\n
Incidentally, the computer I use has not been installed Open Office\/Libre Office, it seems to take a long time if I have to download and install the program. So with the help of Google, I finally found a way to unprotect the Excel Sheet using VB (Visual Basic) Script. <\/i><\/div>\n
 <\/i><\/div>\n<\/div>\n\n\n\n

The following is a step by step Unprotect Microsoft Excel Sheet using VB Script:<\/h2>\n\n\n\n
  1. Open the protected excel file<\/li>
  2. Press the combination key \"ALT+F11\u2033<\/li>
  3.  Click Insert > module<\/li>
  4. copy and paste the following code:<\/li><\/ol>\n\n\n\n
    Sub InternalPasswords()

    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer

    On Error Resume Next

    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126

    ActiveWorkbook.Unprotect Chr(i) & Chr(j) & Chr(k) & _
    Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
    & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
    Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
    & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

    If ActiveWorkbook.ProtectStructure = False Then

    If ActiveWorkbook.ProtectWindows = False Then

    If ActiveSheet.ProtectContents = False Then

    Exit Sub

    End If

    End If

    End If

    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next

    End Sub<\/pre>\n\n\n\n
    5. Click on the sheet or workbook that we want to open the password for
    6. Click Macro > Show Macro > Internal Password > Run
    7. Wait for a while (depending on the size of the file)
    8. If the process is complete, then you can edit the file freely. To check whether the file is still protected, you can also see it in the Review tab, then the icon Unprotect Sheet<\/i> has changed to Protect Sheet.<\/i><\/p>\n\n\n\n
    Hopefully it will be useful if one day you forget the sheet protection password or need to edit a file that turns out to be protected.<\/p>\n\n\n\n
     <\/div>\n\n\n\n
    -><\/p>","protected":false},"excerpt":{"rendered":"
    This morning, a colleague came with an excel file that could not be edited, because it was sheet-protected by the author.<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,13],"tags":[28],"class_list":["post-162","post","type-post","status-publish","format-standard","hentry","category-tips-trik","category-troubleshooting","tag-excel"],"magazineBlocksPostFeaturedMedia":{"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"trp-custom-language-flag":false,"colormag-highlighted-post":false,"colormag-featured-post-medium":false,"colormag-featured-post-small":false,"colormag-featured-image":false,"colormag-default-news":false,"colormag-featured-image-large":false,"colormag-elementor-block-extra-large-thumbnail":false,"colormag-elementor-grid-large-thumbnail":false,"colormag-elementor-grid-small-thumbnail":false,"colormag-elementor-grid-medium-large-thumbnail":false},"magazineBlocksPostAuthor":{"name":"armant","avatar":"https:\/\/secure.gravatar.com\/avatar\/55e5a6dcbb4c3a5e6c85f92f09de4fdbbf64d6340a0b4784c64e88a53efee836?s=96&d=mm&r=g"},"magazineBlocksPostCommentsNumber":"49","magazineBlocksPostExcerpt":"Pagi ini ada seorang rekan yang datang dengan membawa file excel yang tidak bisa diedit, karena diproteksi sheet  oleh pembuatnya.","magazineBlocksPostCategories":["Tips & Trik","Troubleshooting"],"magazineBlocksPostViewCount":4521,"magazineBlocksPostReadTime":3,"magazine_blocks_featured_image_url":{"full":false,"medium":false,"thumbnail":false},"magazine_blocks_author":{"display_name":"armant","author_link":"https:\/\/agusarmanto.com\/en\/author\/armant"},"magazine_blocks_comment":58,"magazine_blocks_author_image":"https:\/\/secure.gravatar.com\/avatar\/55e5a6dcbb4c3a5e6c85f92f09de4fdbbf64d6340a0b4784c64e88a53efee836?s=96&d=mm&r=g","magazine_blocks_category":"Tips & Trik<\/a> Troubleshooting<\/a>","yoast_head":"\nCara Membuka Proteksi Sheet Microsoft Excel tanpa password<\/title>\n<meta name=\"description\" content=\"Membuka Proteksi Sheet Microsoft Excel (macro protection), tidak bisa diedit, dipassword. Cara termudah Unprotect sheet excel tanpa harus tahu passwordnya!!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/agusarmanto.com\/en\/how-to-unprotect-microsoft-excel-sheet-without-password\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuka Proteksi Sheet Microsoft Excel tanpa password\" \/>\n<meta property=\"og:description\" content=\"Membuka Proteksi Sheet Microsoft Excel (macro protection), tidak bisa diedit, dipassword. Cara termudah Unprotect sheet excel tanpa harus tahu passwordnya!!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/agusarmanto.com\/en\/how-to-unprotect-microsoft-excel-sheet-without-password\" \/>\n<meta property=\"og:site_name\" content=\"Agus Armanto\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-13T20:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-28T16:43:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/agusarmanto.com\/wp-content\/uploads\/2014\/03\/protectSheet-6320984.jpg\" \/>\n<meta name=\"author\" content=\"armant\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"armant\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Unprotect Microsoft Excel Sheet without Password","description":"Unprotect Microsoft Excel Sheet (macro protection), cannot be edited, passworded. The easiest way to unprotect excel sheet without knowing the password!!!","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:\/\/agusarmanto.com\/en\/how-to-unprotect-microsoft-excel-sheet-without-password","og_locale":"en_US","og_type":"article","og_title":"Cara Membuka Proteksi Sheet Microsoft Excel tanpa password","og_description":"Membuka Proteksi Sheet Microsoft Excel (macro protection), tidak bisa diedit, dipassword. Cara termudah Unprotect sheet excel tanpa harus tahu passwordnya!!","og_url":"https:\/\/agusarmanto.com\/en\/how-to-unprotect-microsoft-excel-sheet-without-password","og_site_name":"Agus Armanto","article_published_time":"2014-03-13T20:25:00+00:00","article_modified_time":"2020-04-28T16:43:20+00:00","og_image":[{"url":"https:\/\/agusarmanto.com\/wp-content\/uploads\/2014\/03\/protectSheet-6320984.jpg","type":"","width":"","height":""}],"author":"armant","twitter_card":"summary_large_image","twitter_misc":{"Written by":"armant","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password#article","isPartOf":{"@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password"},"author":{"name":"armant","@id":"https:\/\/agusarmanto.com\/#\/schema\/person\/5d92cda20538fdf49269fd2517bd9269"},"headline":"Cara Membuka Proteksi Sheet Microsoft Excel tanpa password","datePublished":"2014-03-13T20:25:00+00:00","dateModified":"2020-04-28T16:43:20+00:00","mainEntityOfPage":{"@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password"},"wordCount":337,"commentCount":49,"image":{"@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password#primaryimage"},"thumbnailUrl":"https:\/\/agusarmanto.com\/wp-content\/uploads\/2014\/03\/protectSheet-6320984.jpg","keywords":["excel"],"articleSection":["Tips & Trik","Troubleshooting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password#respond"]}]},{"@type":"WebPage","@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password","url":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password","name":"How to Unprotect Microsoft Excel Sheet without Password","isPartOf":{"@id":"https:\/\/agusarmanto.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password#primaryimage"},"image":{"@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password#primaryimage"},"thumbnailUrl":"https:\/\/agusarmanto.com\/wp-content\/uploads\/2014\/03\/protectSheet-6320984.jpg","datePublished":"2014-03-13T20:25:00+00:00","dateModified":"2020-04-28T16:43:20+00:00","author":{"@id":"https:\/\/agusarmanto.com\/#\/schema\/person\/5d92cda20538fdf49269fd2517bd9269"},"description":"Unprotect Microsoft Excel Sheet (macro protection), cannot be edited, passworded. The easiest way to unprotect excel sheet without knowing the password!!!","breadcrumb":{"@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password#primaryimage","url":"https:\/\/agusarmanto.com\/wp-content\/uploads\/2014\/03\/protectSheet-6320984.jpg","contentUrl":"https:\/\/agusarmanto.com\/wp-content\/uploads\/2014\/03\/protectSheet-6320984.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/agusarmanto.com\/cara-membuka-proteksi-sheet-microsoft-excel-tanpa-password#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/agusarmanto.com\/"},{"@type":"ListItem","position":2,"name":"Cara Membuka Proteksi Sheet Microsoft Excel tanpa password"}]},{"@type":"WebSite","@id":"https:\/\/agusarmanto.com\/#website","url":"https:\/\/agusarmanto.com\/","name":"Agus Armanto","description":"Technology Insights, Visual Inspiration, Travel, Sports, Modern Lifestyle.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/agusarmanto.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/agusarmanto.com\/#\/schema\/person\/5d92cda20538fdf49269fd2517bd9269","name":"armant","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/55e5a6dcbb4c3a5e6c85f92f09de4fdbbf64d6340a0b4784c64e88a53efee836?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/55e5a6dcbb4c3a5e6c85f92f09de4fdbbf64d6340a0b4784c64e88a53efee836?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/55e5a6dcbb4c3a5e6c85f92f09de4fdbbf64d6340a0b4784c64e88a53efee836?s=96&d=mm&r=g","caption":"armant"},"url":"https:\/\/agusarmanto.com\/en\/author\/armant"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/posts\/162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/comments?post=162"}],"version-history":[{"count":2,"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/posts\/162\/revisions"}],"predecessor-version":[{"id":902,"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/posts\/162\/revisions\/902"}],"wp:attachment":[{"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/media?parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/categories?post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/agusarmanto.com\/en\/wp-json\/wp\/v2\/tags?post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}