{"id":2803,"date":"2021-08-27T06:56:57","date_gmt":"2021-08-27T06:56:57","guid":{"rendered":"https:\/\/quickdata.org\/blog\/?p=2803"},"modified":"2021-11-12T04:34:30","modified_gmt":"2021-11-12T04:34:30","slug":"remove-vba-password-from-excel-file","status":"publish","type":"post","link":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/","title":{"rendered":"How to Remove VBA Password from Excel File in Multiple Ways"},"content":{"rendered":"<p>Are you also looking for a solution to remove VBA password from Excel file? Do you want to unlock .XLS file? If yes, then there is no need to panic now, you are at the right place. In this blog, we are going to discuss about different methods to remove password from excel using VBA. You can just follow this blog thoroughly to know the solutions. But, before jumping to the solutions let\u2019s discuss about a real time user query.<\/p>\n<h3>User Queries<\/h3>\n<blockquote><p>\u201cHey, I am James. I work with a lot of excel files on daily-basis. Somehow, I have forgotten VBA passwords of some of my Excel files. Those files include many crucial data, which I cannot afford to lose. So, someone please suggest me a method to do the same.\u201d<\/p>\n<p>\u201cCan anyone suggest a method to remove password from excel using VBA? Actually, the scenario is that I have created some files in Microsoft excel. These files contains some confidential information, but somehow I have lost the passwords of these files and I want to open these files anyhow, so, please suggest me a way to do that.\u201d<\/p><\/blockquote>\n<p>These are some of the common problems which user faces. So, let us take a look on both the manual and professional approach to Remove the VBA password from Excel file.<\/p>\n<h2>Remove VBA password from Excel file Using Manual Methods<\/h2>\n<p>Before starting the manual approach. Go through the prerequisites of the manual methods:-<\/p>\n<ul>\n<li>Always keep a complete backup of your VBA files<\/li>\n<li>We know that XLSM and XLSX files are similar to each other but still, you should enable the macros<\/li>\n<\/ul>\n<h3>Method 1 \u2013 Use Hex Editor to Remove VBA Password<\/h3>\n<p>Follow the steps given below to Remove VBA password from Excel file:-<\/p>\n<ul>\n<li>First step is to create a new XLS file using any Hex Editor<\/li>\n<li>Now, Press \u201cAlt+F11\u201d keys together, and set a password in the VBA field<\/li>\n<li>After this, just save the file and click on the \u201cExit\u201d button<\/li>\n<li>Here, you need to open the newly created file<\/li>\n<li>After opening the file, copy each single line which is starting with:<br \/>\nCMG=\u2026.<br \/>\nDPB=\u2026<br \/>\nGC=\u2026<\/li>\n<li>Now, using Hex editor open the file that you want to unlock and paste all these copied lines<\/li>\n<li>After this, you need to save the files and just click on the \u201cExit\u201d button to remove the password from Excel file<\/li>\n<li>At last, just open the excel file in which you want to see the code and simply enter the dummy password which you used in the previous step.<\/li>\n<\/ul>\n<h3>Method 2 \u2013 remove password from excel Using WinZip\/ WinRAR<\/h3>\n<p>Go through the steps given below:-<\/p>\n<ul>\n<li>Firstly, change the .xlsm file extension to .zip<\/li>\n<li>Using the WinRAR\/ WinZip, open the .zip file and select .xl folder<\/li>\n<li>Now, you need to extract vbaProject.bin file<\/li>\n<li>After extracting the file, open it in Hex editor<\/li>\n<li>Here, search for the DPB file and replace it with DPX file and save that particular file<\/li>\n<li>Now you can save this latest file with the previous vbaProject.bin file under the zip file<\/li>\n<li>After this, you need to change the ZIP file extension to XLSM file<\/li>\n<li>In MS Excel, start the visual basic and go to the \u201cTools\u201d option<\/li>\n<li>Now, choose the \u201cVBA Project Properties\u201d option and click on the \u201cProtection\u201d option<\/li>\n<li>In this step, you need to add a new password and after that save that file in .xlsm file format<\/li>\n<li>At last, you need to exit the VBA file and just re-open it using the new password<\/li>\n<\/ul>\n<h3>Method 3 \u2013 Use Workbook Method<\/h3>\n<p>Just follow the given procedure to Remove VBA password from Excel file:-<\/p>\n<ul>\n<li>Open the Workbook which contains the all the sheets<\/li>\n<li>Press the \u201cAlt + F11\u201d keys together to verify the sheet and open the Visual Basic Editor<\/li>\n<li>Now, you need to type Insert-Module and after that paste the code there<\/li>\n<li>Close the VB Editor and search for the workbook from which you want to remove the passwords<\/li>\n<li>Now, you have to type the Tools-Macros-Macros and do a double click on the Password breaker.<\/li>\n<\/ul>\n<p>So, these are some of the manual methods which you can use to remove password from excel using VBA. But, if you do not have technical knowledge then this method will be a bit tricky and confusing for you. This manual approach will consume more time and efforts. So, in the next section we will discuss about the professional approach to unlock the password protected excel file using VBA.<\/p>\n<h2>Professional Approach to Remove VBA Password from Excel File<\/h2>\n<p>You can use the automated tool to easily unlock the VBA password protected files. Follow the procedure mentioned below:-<\/p>\n<p class=\"text-center mr-2\"><a class=\"btn btn-success btn-lg btn-md-block p-3 text-white\" href=\"https:\/\/quickdata.org\/download\/SYS1V1P1R\/93\">Download Tool<\/a> <a class=\"btn btn-lg btn-md-block text-white\" style=\"background: #ff6800; color: #fff !important;\" href=\"https:\/\/quickdata.org\/buy\/SYS1V1P1R\/93\" target=\"_blank\" rel=\"noopener noreferrer\">Purchase Now<\/a><\/p>\n<ul>\n<li>Install and run the VBA Password Remover software on your system<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/systoolskart.com\/imgp\/vba-password-remover\/v6\/main.webp\"><\/p>\n<ul>\n<li>Click on the \u201cAdd files\/ Add folder\u201d option to browse the password protected files<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/systoolskart.com\/imgp\/vba-password-remover\/v6\/vba1.webp\"><\/p>\n<ul>\n<li>Now choose the files from which you want to remove password and click on the \u201cOpen\u201d button<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/systoolskart.com\/imgp\/vba-password-remover\/v6\/vba2.webp\"><\/p>\n<ul>\n<li>At last, click on the \u201cReset\u201d option.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/systoolskart.com\/imgp\/vba-password-remover\/v6\/vba6.webp\"><\/p>\n<h4>Advanced Features of VBA Password Remover Tool<\/h4>\n<ul>\n<li>Tool supports to <strong>remove passwords<\/strong> from <strong>Single<\/strong> as well as <strong>Multiple VBA<\/strong> files<\/li>\n<li>Allows restoring VBA macro passwords from <strong>PowerPoint, Excel, Access<\/strong> and <strong>Word<\/strong> files<\/li>\n<li>User can easily <strong>remove password<\/strong> of <strong>any length<\/strong><\/li>\n<li>Software is compatible with <strong>Windows OS<\/strong> and <strong>MS Office<\/strong><\/li>\n<li>Tool allows to <strong>eliminate old password<\/strong> and <strong>generate<\/strong> a <strong>new<\/strong> one<\/li>\n<li>Software also provides<strong>progressreport<\/strong><\/li>\n<\/ul>\n<h4>Summing Up<\/h4>\n<p>In the above blog, we have discussed about different methods to Remove VBA password from Excel file. User can use any of the manual methods which are mentioned above. But, as we mentioned above that those methods are bit technical. So, you can switch to the automated tool to unlock the VBA files. This tool has a user-friendly interface and safe to use.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you also looking for a solution to remove VBA password from Excel file? Do you want to unlock .XLS <\/p>\n","protected":false},"author":4,"featured_media":2804,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-2803","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-password-recovery"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Remove VBA Password from Excel File in Multiple Ways<\/title>\n<meta name=\"description\" content=\"Do you want to remove VBA password from Excel file? Yes, just follow this blog thoroughly to know the solutions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ashwani Tiwari\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/\"},\"author\":{\"name\":\"Ashwani Tiwari\",\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/#\\\/schema\\\/person\\\/b21f016f4b7a0774cf7f199fd4573479\"},\"headline\":\"How to Remove VBA Password from Excel File in Multiple Ways\",\"datePublished\":\"2021-08-27T06:56:57+00:00\",\"dateModified\":\"2021-11-12T04:34:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/\"},\"wordCount\":964,\"image\":{\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Remove-passwords-from-an-Excel-Workbook.png\",\"articleSection\":[\"Password Recovery\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/\",\"url\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/\",\"name\":\"How to Remove VBA Password from Excel File in Multiple Ways\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Remove-passwords-from-an-Excel-Workbook.png\",\"datePublished\":\"2021-08-27T06:56:57+00:00\",\"dateModified\":\"2021-11-12T04:34:30+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/#\\\/schema\\\/person\\\/b21f016f4b7a0774cf7f199fd4573479\"},\"description\":\"Do you want to remove VBA password from Excel file? Yes, just follow this blog thoroughly to know the solutions.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Remove-passwords-from-an-Excel-Workbook.png\",\"contentUrl\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Remove-passwords-from-an-Excel-Workbook.png\",\"width\":889,\"height\":500,\"caption\":\"remove VBA password from Excel file\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/remove-vba-password-from-excel-file\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Remove VBA Password from Excel File in Multiple Ways\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/\",\"name\":\"QuickData Blog Section\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/#\\\/schema\\\/person\\\/b21f016f4b7a0774cf7f199fd4573479\",\"name\":\"Ashwani Tiwari\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2140b54c0cce2d0e03ba475ec1ffb609754f10e0acdd155f2c328439daf97c30?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2140b54c0cce2d0e03ba475ec1ffb609754f10e0acdd155f2c328439daf97c30?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2140b54c0cce2d0e03ba475ec1ffb609754f10e0acdd155f2c328439daf97c30?s=96&d=mm&r=g\",\"caption\":\"Ashwani Tiwari\"},\"description\":\"A writer in technology who specializes in creating explainer content published in blogs, how-to guides, articles, and training manuals. He seeks to provide clear actionable answers to technical queries to make it easier for readers to solve them.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ashwani-tiwari\\\/\"],\"url\":\"https:\\\/\\\/quickdata.org\\\/blog\\\/author\\\/ashwani\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Remove VBA Password from Excel File in Multiple Ways","description":"Do you want to remove VBA password from Excel file? Yes, just follow this blog thoroughly to know the solutions.","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:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/","twitter_misc":{"Written by":"Ashwani Tiwari","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/#article","isPartOf":{"@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/"},"author":{"name":"Ashwani Tiwari","@id":"https:\/\/quickdata.org\/blog\/#\/schema\/person\/b21f016f4b7a0774cf7f199fd4573479"},"headline":"How to Remove VBA Password from Excel File in Multiple Ways","datePublished":"2021-08-27T06:56:57+00:00","dateModified":"2021-11-12T04:34:30+00:00","mainEntityOfPage":{"@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/"},"wordCount":964,"image":{"@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/#primaryimage"},"thumbnailUrl":"https:\/\/quickdata.org\/blog\/wp-content\/uploads\/2021\/08\/Remove-passwords-from-an-Excel-Workbook.png","articleSection":["Password Recovery"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/","url":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/","name":"How to Remove VBA Password from Excel File in Multiple Ways","isPartOf":{"@id":"https:\/\/quickdata.org\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/#primaryimage"},"image":{"@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/#primaryimage"},"thumbnailUrl":"https:\/\/quickdata.org\/blog\/wp-content\/uploads\/2021\/08\/Remove-passwords-from-an-Excel-Workbook.png","datePublished":"2021-08-27T06:56:57+00:00","dateModified":"2021-11-12T04:34:30+00:00","author":{"@id":"https:\/\/quickdata.org\/blog\/#\/schema\/person\/b21f016f4b7a0774cf7f199fd4573479"},"description":"Do you want to remove VBA password from Excel file? Yes, just follow this blog thoroughly to know the solutions.","breadcrumb":{"@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/#primaryimage","url":"https:\/\/quickdata.org\/blog\/wp-content\/uploads\/2021\/08\/Remove-passwords-from-an-Excel-Workbook.png","contentUrl":"https:\/\/quickdata.org\/blog\/wp-content\/uploads\/2021\/08\/Remove-passwords-from-an-Excel-Workbook.png","width":889,"height":500,"caption":"remove VBA password from Excel file"},{"@type":"BreadcrumbList","@id":"https:\/\/quickdata.org\/blog\/remove-vba-password-from-excel-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quickdata.org\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Remove VBA Password from Excel File in Multiple Ways"}]},{"@type":"WebSite","@id":"https:\/\/quickdata.org\/blog\/#website","url":"https:\/\/quickdata.org\/blog\/","name":"QuickData Blog Section","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quickdata.org\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quickdata.org\/blog\/#\/schema\/person\/b21f016f4b7a0774cf7f199fd4573479","name":"Ashwani Tiwari","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/2140b54c0cce2d0e03ba475ec1ffb609754f10e0acdd155f2c328439daf97c30?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2140b54c0cce2d0e03ba475ec1ffb609754f10e0acdd155f2c328439daf97c30?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2140b54c0cce2d0e03ba475ec1ffb609754f10e0acdd155f2c328439daf97c30?s=96&d=mm&r=g","caption":"Ashwani Tiwari"},"description":"A writer in technology who specializes in creating explainer content published in blogs, how-to guides, articles, and training manuals. He seeks to provide clear actionable answers to technical queries to make it easier for readers to solve them.","sameAs":["https:\/\/www.linkedin.com\/in\/ashwani-tiwari\/"],"url":"https:\/\/quickdata.org\/blog\/author\/ashwani\/"}]}},"_links":{"self":[{"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/posts\/2803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/comments?post=2803"}],"version-history":[{"count":0,"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/posts\/2803\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/media\/2804"}],"wp:attachment":[{"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/media?parent=2803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/categories?post=2803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quickdata.org\/blog\/wp-json\/wp\/v2\/tags?post=2803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}