Re: Excel Sheet hide/Unhide and protect/unprotect with password with VBA The commands you need are listed below, use the F1 help key on the keywords to find out more about them so that you can tailor them for your own use. Protect workbook with password. Hence in this article I am going to tell you about VBA Excel password breaker tool which allows you to remove Excel macro. To break password protected Excel 2007 add-on with VBA (. Some scenarios can raises need of Excel unlocker application are, if users forgot their password by chance, due to organizational changes, due to job. Locking a worksheet in Excel 2013 gives you the freedom to share the file with someone, without worrying about that person making unwanted changes to the data or its formatting. Un-protect an Excel Workbook. I need to be able to open them all and change one cell in each file, save it and close. Part 2: Unlock WorkSheet/Workbook Password for Editing. if the Excel workbook itself is not password protected and only the VBA project. We can record a macro to get the basic code and then modified to suit our needs. The code line below closes close-open-workbooks. VBA Code to Password Protect an Excel file. Excel - Workbook call VBA code in external file? - posted in Business Applications: I have several Excel workbooks that all use the same VBA code. If the worksheet is protected, do the following: On the Review tab, click Unprotect Sheet (in the Changes group). My problem is when i close the workbook, the "VBA project. With our service, you can instantly remove protection from Microsoft Excel spreadsheets, Word documents, PowerPoint presentations and VBA projects. Visible = xlSheetHidden Or sh. It is critical that you remember your password. Sometimes the password-protected sheet cannot be opened. Locking a worksheet in Excel 2013 gives you the freedom to share the file with someone, without worrying about that person making unwanted changes to the data or its formatting. Almost ALL Excel. If a workbook is new and not yet saved, it will be assigned a temporary name. Store the passwords that you write down in a secure place away from the information that they help protect. To use Excel VBA, we must have Excel 2010 or recent. If you forget your password, Microsoft cannot retrieve it. How to unprotect Excel Workbook and Worksheet with or without password. Generating password-protected PDF using Excel VBA. Open your worksheet which has been protected before. Make a backup of the file where the VBA project is password-protected. Add password to workbook. The only way to protect data on a sheet using the excel tools is to protect the sheet. xls file type. FIRST BACKUP the excel file you don't know the VBA password for, then open it with your hex editor, and paste the above copied lines from the dummy file. Save VBA Method. Excel VBA Delete Row: Step-by-Step Guide and 12 Code Examples to Delete Rows with Macros By J. How to Lock VBA Project with Password in Excel 2016 / 2013 How can I lock down the VBA project to prevent others from seeing or messing up your code? Just like you can use password to protect a workbook or worksheet , you can also set a password to protect VBA macros in Excel. Recover lost worksheet protection password in Excel with VBA code. Explore this Article Secure VBA Code with a Password Hide VBA Code in a Read-Only File with Access 2007 Protect Your VBA Code by Making an Add-In Ask a Question Related Articles wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. Visual Basic for Applications was developed by Microsoft to allow Microsoft Office Suite users to add enhanced functionality to the standard apps, like Excel. The Excel worksheet password protection works by converting the input password to a hash and stores it. How to Unprotect Excel WorkSheet with or without Password. I forgot the password set for excel vba macro and i can not download hex Editor. To break password protected Excel 2007 macro-enabled workbook (. Excel VBA copy contents of protected worksheet. 0 through Excel XP, 2003). The GetObject() open prompts your user for the password, and then you are free to open the file using your preferred approach. Jun 10, 2017. I found this bit of VBA code on the web. Locate the Locked & Lock Text checkboxes. A sharing password for shared workbooks (not so commonly used) 4. So far I can get everything to work besides the Submit part. Recent snippets tagged 'excel'. As I said, I am happy for the password to be visible in VBA if needs be. Store the passwords that you write down in a secure place away from the information that they help protect. It should show the option when you run Macro. Part 2: Unlock WorkSheet/Workbook Password for Editing. The following VBA code can help you to quickly cancel your original passwords in a worksheet. Part 3: Use VBA Code to Crack Excel Workbook Password. This Excel add-in works fine in Excel 2007 and Excel 2010. Similar Threads. If you have forgotten your Vba code password or your project was locked this is the solution for you. This will open the Microsoft Visual Basic for Applications window. Excel Macros : VBA Expiry date for Excel Workbook Many times we have a situation where we need to force users to use updated file and stop using the old version of worksheet. Open a password protected excel workbook from second workbook to fetch data using dynamic connection. VBA code stored in worksheets (document modules) can be read from workbooks with unprotected structure (Review > Protect Workbook), even if the VBA project is password locked or unviewable. The GetObject() open prompts your user for the password, and then you are free to open the file using your preferred approach. bas) then run the imported macro (testone). In the above blog, we have tried to resolve the issue of forgot VBA project password for Excel 2010. Protect VBA Code protects VBA projects from password cracking in MS Excel, Word, PowerPoint, Access, Publisher, Outlook, FrontPage, PowerPoint and Project files. MS Excel 2007 creates XLSX file by default whereas it forms XLSM file when macros are enabled. Forgot Excel password and cannot open the encrypted file? Excel Password Unlocker can effectively recover lost or forgotten open password from encrypted MS Office Excel 97-2010 files through Brute-force attack, Brute-attack with Mask attack and Dictionary attack. It is one of the simplest and quick. The macro will return you to the worksheet you want to unprotect. A common request across the Excel forums is looking for some way to remove a password from the worksheet/workbook/VBA project. Save that particular file and then, click on Exit. all code password: Login with Facebook. Excel 2010 is a type of spreadsheat software developed by Microsoft, allowing users to create detailed workbooks for records purposes and more. com I have an excel 2010 macro enabled workbook for which I have forgotten the password. I have a popular VBA code to unprotect a worksheet, but I am still running into the issue that the Workbook is protected. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. Unlocking a Worksheet with an Unknown Password. Right Click in the project explorer window and select Insert > Module. VBA code usually helps to recover lost worksheet passwords effortlessly. Type the following VBA codes on the Module: Sub UnprotectWorkbook() 'Unprotect Excel workbook password protection. Excel VBA Add password to Excel workbook in folder. Similar Threads. But for may unknown reasons, you will find that VBA code won't always works smoothly!. Open() and Workbook. It can be called through VBA, but unfortunately cannot be entered directly in a worksheet cell. Sheet Protect (User Interface only) using VBA Submitted by Vishesh on 19 April, 2011 - 14:31 Generally, if you want your vba code to run on a protected sheet, you wrap your code in unprotect/protect statements in every procedure or function. Whether you like the new game or not, anything that makes money rolling is 'good'. Excel 2010 is a type of spreadsheat software developed by Microsoft, allowing users to create detailed workbooks for records purposes and more. Private Sub Workbook_Open() ThisWorkbook. Password protecting an Excel file achieves two main objectives (1) prevents unauthorized access to the Excel file (2) prevents unauthorized modification of the Excel file. protect excel spreadsheet Software - Free Download protect excel spreadsheet - Top 4 Download - Top4Download. Part 1: How to Use VBA Code to Crack Exel Workboot Password. Trader's Useful Excel VBA Code In the process of creating VBA code, I found myself wanting a central location of commonly used VBA code for quick reference. Crack a password-protected Excel VBA project. Figure 8 – Unlock password protected worksheet. The code seems to also work with workbooks. xls" statement. Method 2 This method is way easy to use, but you would lose all your macro/add-in codes, named ranges etc. I have an Excel workbook. Delete all open workbooks and close the Excel application. Double-click it and paste the code you have just copied in the code area on the right. VBA Code to Unlock a Locked Excel Sheet: 4 Steps. I found a way to get Excel to open an older. It also removes workbook structure passwords as fast. If you lose the password, you can't open or gain access to the password-protected workbook. Is there a way to break excel vba password without using hex editor [duplicate. Download with Google Download with Facebook or download with email. com offers free software downloads for Windows, Mac, iOS and Android computers and mobile devices. VBA Code to Password Protect an Excel file. Insert a Module from Insert Menu. Remember this is not 100% secure, but will prevent most users from viewing or altering your code. I have applied the code below to VBA to activate the Spell Check feature on a protected worksheet. It also hides the Worksheet from the user when they right-click the tabs at the bottom. If user wants to see data in workbook user should have password to view data in the workbook. Excel VBA - Cell lock with multiple range using worksheet_change() Hi All, Before using this code, from excel Goto Format|Cells then select Protection tab and. Forgot the password to unprotect your Excel Workbook? Microsoft highly recommend you to record and restore your password to a safe place when protect the Excel Workbook with password, because it don't support to recover the forgotten password for you. Excel VBA copy contents of protected worksheet. Excel has updated their sheet protection security in Excel 2013 and newer so this macro won't work anymore, see here. It's free to try - submit your document now!. Select the whole worksheet by clicking the Select All button. I've downloaded and "added in" password. Column letter Equivalent of Column Number in Excel Convert Access Database to Excel Workbook Convert an Excel column number to its string equivalent Convert Excel Formulas to Absolute or Relative (Excel Macro) Convert Excel spread sheet to an XML document. The code used in this instruction is one of the simplest I've found. Where you get the passwords from is up to you. In this article, you will learn how to protect & unprotect all the sheets with VBA code. with a simple editor (again), open the excel file you don;t know the VBA password for, and paste the above copied lines from the dummy file. I am an analyst, I have protected sheets in Excel 2013 and sent the workbook to a colleague who has Excel 2010 only. The solution is to remove the password protection from the Excel Sheet. It is one of the perfect solutions through which users can easily access password protected VBA files in a quick and efficient way. Now, there is another XML file is created, known as vbaProject. Open a password protected excel workbook from second workbook to fetch data using dynamic connection. Rather it is simply done by passing the password parameters in Workbooks. save the excel file and exit. Dim l As Integer, m As Integer, n As Integer. Top free free download unlock vba code excel password downloads. There are many reasons why sometimes we need to password protect them but most of them are for keeping the content of the worksheet intact and unmodified, or keeping the confidentiality of the content, e. >>Could somebody please post some example code showing how to encrypt a workbook once I have it open (using VBA)? A good way to learn how to get the sample code for object models of Word, Excel, and Powerpoint, based on what you want to do as a user, is to use the Macro Recorder. In this post we provide a macro that can be used to automatically remove Worksheet Protection to single Worksheet, some Worksheets or all Worksheets in a Workbook. How to Loop Through Worksheets in a Workbook in Excel VBA? Using the For Each Loop The code below loops through all worksheets in the workbook, and activates each worksheet. These formats have been introduced with Excel 2007 and used in Excel 2007-2019. VBA Code to Unlock a Locked Excel Sheet: If you have ever forgotten a password for one of your excel worksheets you know how frustrating that can be. Excel save the file contents in which each cell includes formulas, formats, VBA code, conditional formatting, etc. Dim i4 As Integer, i5 As Integer, i6 As Integer. A common request across the Excel forums is looking for some way to remove a password from the worksheet/workbook/VBA project. 'Code by Mahipal Padigela 'Open Microsoft Excel 'Goto VBA Editor (Press Control+F11 or navigate Menu Tools-->Macro-->Visual BAsic Editor) 'Insert a Module (Right click your file name in the VB editor-->Insert-->Module) 'Paste the following code into the Module1 Sub makeSheetsVisible() Dim sh As Excel. Store the passwords that you write down in a secure place away from the information that they help protect. If you need to crack a Word Document as well, check out my Crack Microsoft Word Password Free post. Excel ® 2013 Power Programming with VBA. VBA code stored in worksheets (document modules) can be read from workbooks with unprotected structure (Review > Protect Workbook), even if the VBA project is password locked or unviewable. Different kinds of workbook protection. wsUnprotector is an Excel Add-in that recovers and removes worksheet passwords in under 5 seconds on a business class pc (that same one that VBA code takes 2 minutes on). Now, open the excel file you need to see the VBA code in. With the help of this software user can remove VBA password from MS Access (mdb, accdb), Word (doc, dot) and Excel (xls, xlsm, xlsb, xlam) file source code. I have a user who had forgotten the password for an Excel 2010 file. Open this, and any modification or viewing the VBA script/macro requires unprotecting the sheet first. It was tested on the workbooks created in Excel 2007/2010. Users can easily unprotect VBA project in Excel without password through common fixes. VBA Code to Password Protect an Excel file. The main advantage of the module method is that it allows saving the code in the file, so that it can be used again later. How to unprotect a password protected. As I said, I am happy for the password to be visible in VBA if needs be. Get easy and simple method to remove VBA password from Excel 2013 file and access all the data that is locked at the time. Protect VBA code with password. workbook tool remover remove password online macro how cracker crack code excel vba excel-vba hex-editors Create Excel(. All YOU need to do, is follow the link here or above, copy the code, open the workbook you want to "crack" and press ALT+F11, this will open the VBA (Visual Basic) editor. Visual Basic for Applications (VBA) is the simple programming language used within Excel to develop macros and complex programs. This Add-In can remove password if any of the excel sheet is protected by password. xla file type. In order to make changes to the structure of a protected (not encrypted) workbook, you need to unlock it first. Best Excel Password Recovery software to crack Excel sheet password after then all Excel friends easily get back open Excel file without any hesitation. Is there any way to recover the password of that Excel sheet?. In this article, I’m going to show you the fastest and most efficient way to copy and filter data no matter what your task is. Whether you like the new game or not, anything that makes money rolling is 'good'. Go to Developer Tab > Macros > Select the macro you copied to the other excel file and click on > Run Let me know if you have any questions. Now add password to protect VBA code. & of course you need to dig in more for this. Excel has updated their sheet protection security in Excel 2013 and newer so this macro won't work anymore, see here. Hi All, Is there is way to unlock excel workbook in vba. IPL - the grand success. Save that particular file and then, click on Exit. Now, open the excel file you need to see the VBA code in. It works for Excel 2010/2013/2016. This is my own file, few months ago,i tried VBA password to learn strong protection. The solution is to remove the password protection from the Excel Sheet. I have a password protected sheet in a Excel 2013 workbook (that someone has manged to work out the original password and change) that the following script does not work in: Sub PasswordBreaker() 'Breaks worksheet password protection. Under "Tools" in the menu at the top of the screen, click "Options" and then navigate to the "Security" tab. Please follow the below step by step instructions to execute the above mentioned VBA macros or codes: Open an Excel Workbook. Hack Excel Spreadsheet Password with VBA The use of VBA Code is possibly one of the oldest ways to hack Excel password. The Close and Open Method in Excel VBA can be used to close and open workbooks. Excel file maybe be protected with different category of passwords like read-only password, sheet protection password, open password, workbook protection password, VBA protection password, etc. Thanks for your response, I was able to achieve what I want by having three different VBA Code and having a command button. Put your authentication macro in that sub and it will fire as soon as the workbook is opened. Protect workbook with password. Unprotect Method. With this you can easily unlock the Excel workbook. Caution: When you create a password for a workbook, write down the password and keep it in a secure place. docx), PDF File (. We had to use the service called Password-find. Because you can customize the protection for any worksheet, it's important to review what the user can and cannot do once its locked. Recover open Excel worksheet password and unlock excel file. As I said, I am happy for the password to be visible in VBA if needs be. If you forget your password, Microsoft cannot retrieve it. It was tested on the workbooks created in Excel 2007/2010. When starting a VBA procedure it is often necessary to unlock your worksheet, removing the password. To learn to unlock the true power of Excel, take a look at the Visual Basic for Excel – Microsoft VBA Excel Tutorial. formula for. Featured VBA Project free downloads and reviews. Within the code I have ensured that certain worksheets remain hidden. I would like, if it's possible, to have a macro button on my Excel toolbar, which, when selected, will trigger a personal macro that will insert a pre-determined password into the vba password dialogue box that appears when I try to open my workbook's vba editor. VBA Code to Password Protect an Excel file. This post is purely for Educational purpose and kindly don't misuse this trick to unlock copyrighted Excel Worksheets. XLS file that was protected with a VBA password by a former employee? How to recover or bypass the password on an Excel VBA project? In this tutorial we'll show you a simple way to unlock / recover Excel VBA project password in no time, no matter how complex it is. unprotect and Activesheet. Visual Basic for Applications was developed by Microsoft to allow Microsoft Office Suite users to add enhanced functionality to the standard apps, like Excel. How to Unlock Using Excel VBA code. update some 50+ workbooks using an control type workbook which is. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. [insert image] From the Save As dialog box click Tools -> General Options…. Download with Google Download with Facebook or download with email. Go to Developer Tab > Macros > Select the macro you copied to the other excel file and click on > Run Let me know if you have any questions. I am not worried about someone going into the code and seeing the password. Re: opening a password protected spreadsheet in VBA It is simple, if a workbook is password protected on open and you don't know the password then you cannot open it including with VBA. Excel ® 2013 Power Programming with VBA. Thanks for your response, I was able to achieve what I want by having three different VBA Code and having a command button. Figure 8 – Unlock password protected worksheet. This hack can be demonstrated with the following simple steps: Store event code in a worksheet. Delete the password in the "Password to open" field and click "OK. When working with workbook code has password Unprotected, if you want to do any changes in the code first you have to Unprotect the password at the beginning of the procedure and. This code opens a msgbox that asks for a password and then unlocks certain cells based on what the password is. Excel VBA Delete Row: Step-by-Step Guide and 12 Code Examples to Delete Rows with Macros By J. The algorithm ' relies on a backdoor password that can be 1 to 9 characters long where each ' character is either an "A" or "B" except the last which can be any character ' from ASCII code 32 to 255. Sometimes the password-protected sheet cannot be opened. VBA Statement Explanation. Download with Google Download with Facebook or download with email. I have an excel file that I need to crack. VBA Codes. #1: “Excel VBA Code to” technique which can be applied using google search and customizing macro to quickly use ready-made codes with little knowledge of Excel’s programming language In one of our earlier blog, Rishabh has already has shown us how to remove the password. VBA Code to Unlock a Locked Excel Sheet: If you have ever forgotten a password for one of your excel worksheets you know how frustrating that can be. File-level protection is not the same as worksheet protection or workbook protection. Add a module and put some comments like I've done here. I have a popular VBA code to unprotect a worksheet, but I am still running into the issue that the Workbook is protected. Below is an Excel file with protected worksheets which will be unlocked in. Excel VBA - Cells Counting using VBA codes and displaying results in msg box. The password for the VBA code will simply be 1234 (as in the example I'm showing here). I had this request today at work for an Excel workbook and thought I would share it with you. How to Unprotect Excel WorkSheet with or without Password. Last night, I got into the worksheet with that password no problem. So, if you cannot remember the password anymore then you may have to try the following methods to unlock it again, you can unlock Excel Password with VBA Code (Compatible with 2010 or earlier versions) Step 1. Vba Password Recovery Software helps you for Excel Unlock Vba Password. Open the Excel file and press the button on the worksheet to call the userform. Unfortunately, Microsoft has not improved the protection algorithm of VBA projects and commercial tools are available online which can crack any length of VBA password for all Microsoft Excel. Wondering, in Excel Protect Sheet dialog box (Review -> Protect Sheet) you can set protection on a single worksheet. Save the workbook. Multiple User Logins & Passwords In Workbook Nov 4, 2006. Way 1: Unprotect Excel 2016 Workbook without Password using VBA Code. Best Software Available to Unlock Excel File and Open Spreadsheet: Excel users need to use Excel password unlocker software to remove password security from Excel workbook in many situations. You can implement this method without putting macros in your workbook too. With the use of Excel VBA we are able to protect all our worksheets with just the click of a button. I chose to apply the techniques to only Access, Excel, PowerPoint and Word. Share your workbook with others and always work on the latest version for real-time collaboration to help get work done faster. Excel Password Recovery Lastic will not only remove or recover worksheet and workbook passwords, it'll also recover the password to open an Excel document and VBA project passwords too. asp?prod=131 Financial VBA Code for #Excel contains 37 #Excel VBA programs for advanced finance and statistics with. This tip explores how you can get rid of some of the bother by using a single password for multiple workbooks. Bypass Excel Spreadsheet Password by VBA Code. If you ever forgotten a password for one of your excel worksheets or Excel VBA Macro code then you know how frustrating that can be. complex and the file is Excel 2007 or. The only way to protect data on a sheet using the excel tools is to protect the sheet. The macro will return you to the worksheet you want to unprotect. It can recover your lost excel password and unlock locked excel file then you can re-access your excel spreadsheet without creating any problem. Sometimes the password-protected sheet cannot be opened. xls but don't know how that' supposed to work. I have a user who had forgotten the password for an Excel 2010 file. Save saves the relevant workbook. Part 3: Use VBA Code to Crack Excel Workbook Password. But, sometimes, they want to protect the VBA code from being viewed or destroyed by others. If the worksheet is protected, do the following: On the Review tab, click Unprotect Sheet (in the Changes group). Protect vba code 2. Need to unlock an old. Dim i4 As Integer, i5 As Integer, i6 As Integer. docx), PDF File (. If you do a search for "Excel password cracker" or something similar, you will find lots of. I have 140 of these workbooks. Crack a password-protected Excel VBA project. So it is good to write that protection code on workbook open event. Now everyone can access the same file and if someone changes something on that it is very difficult or hard to track who has modified the same. VBA code to print All Charts in a Workbook Function PrintAllChart() Dim ExcelCharts As Object For Each Sheet In Sheets Set ExcelCharts = Sheet. https://www. Generating password-protected PDF using Excel VBA. Where you get the passwords from is up to you. Use this free Excel Password Remover Add-In or VBA code with any Excel sheet to unlock your Excel sheet data. After you have selected the excel workbook, the macro will run at the back end to crack excel sheet password. com/solutions. If the password cannot be provided, the workbook does not open. Download with Google Download with Facebook or download with email. You could possibly protect and unprotect the sheet if it meets a condition using the Worksheet_SelectionChange event. This causes the locked property to be enforced for each cell. This SO article explains this as well, with greater detail: Excel VBA - Automatically Input Password. XLS Padlock is software for Microsoft Excel to copy-protect Excel workbooks. It clearly states the approaches to be followed to unlock password protected excel files using the manual and automated method. How to recovery VBA Project password in Excel 2016 when forgotten or Unknown How to Remove Access 2016 VBA Password Excel Word Powerpoint Hack Crack, Run VBA Code on Protected Worksheet. Question at first was not trying to unlock a spreadsheet, but AN EXCEL FILE, that ask a password when you try to OPEN the FILE, so forget about the VBCode or Macro, you can't use it in a protected Excel FILE. The written instructions are below the video. I have a user who had forgotten the password for an Excel 2010 file. Dim i4 As Integer, i5 As Integer, i6 As Integer. Entering VBA code directly involves … well, entering the code directly. In the Project Explorer in the Visual Basic Editor, activate the workbook that contains the code in question. Finding the maximum value in a range. I know the password to open this file, but I do NOT know the rest of the passwords in this file. xlsm file) you can use Excel Password program. Value = "This is. Everyone's Recent Snippets Tagged 'excel' All. Two years before I set password protection option for one of the sheets. Sometimes the password-protected sheet cannot be opened. Any idea what's going on here. [insert image] From the Save As dialog box click Tools -> General Options…. Excel ® 2013 Power Programming with VBA. To open the VBA editor screen, follow the below mentioned steps: Click on Developer tab. FIRST BACKUP the excel file you don't know the VBA password for, then open it with your hex editor, and paste the above copied lines from the dummy file. There's also another variation of this code floating around that allows you to unlock other workbooks, not just the sheets. I have 140 of these workbooks. This is due to the fact that macros will not execute on an excel workbook until the password is entered - thus the prompt for a password before you can execute your macro code. Among all the third-party methods to unprotect Excel Workbook, Excel Password Recovery is possibly the safest and most effective option. the script took seconds to crack the. Users can easily use a manual solution to reset password of VBA XLA/ XLS files or may opt for a third party tool to complete it in a quick and safe manner. If you have set a password for an Excel workbook, you can remove the password at any time and the workbook can once again be viewed by anyone who tries to open it. Figure 8 – Unlock password protected worksheet. Password crackers are used to "crack" lost or. 2 - Incl KEYGEN & ACTIVAtoR - Protect your vba projects from password cracking. Each method has its own adaptability, and you need to know it in advance. What I don't like about the code is that you need to have the real password somewhere in the code. Online Password Recovery. Sub PasswordBreaker() 'Breaks worksheet password protection. Delete all open workbooks and close the Excel application. Protect Excel Workbook using VBA. Create a password protected excel workbook. Hello Friends, This is a small VBA code to help you in dealing with Protecting and UnProtecting the WorkSheet using Excel Macro. I am new to VBA programming and I am having difficulty with a userform that I have set-up. So it is good to write that protection code on workbook open event. VBA Code to Delete Sheet by Position. When you write Macro / VBA code in Excel, other people can easily see the source code by clicking ALT+F11 and then copy / modify your code. Worksheets("Sheet1"). Let's be honest, most people who use this code use it to unlock other peoples workbooks. It works as a compiler that turns your Excel worksheets, formulas and VBA code into secured applications. Open Excel - VBA Menu. Option 1 – Unprotect all Worksheets. If the Excel.