I need to unlock the VBA project in an Excel file, but I don't know the
I know, that there is a brute-force password cracker for protected
worksheets, but only for worksheets - no VBA projects.
Is there any other tool for this?
Note that I already know, how to extract source codes from Excel file (using
modified ClamAV) - but I need also to modify it, not only extract...
Thanks in advance!
Similar Excel Video Tutorials
Build A Questionnaire
- See how to put the IF function inside a VLOOKUP function, add Data Validation, use an Array formula, unlock cells and protect the sheet all in order ...
Helpful Excel Macros
Delete a VBA Module From Excel
- Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Excel.
reverse excel's password encryption?
I need to modify the vba project but it is password protected. The sheets were also protected but I used a brute force to find AABBBBABBBAN
Since the encryption doesn't work for vba, is there anyway I can find out what the original password was before it was encrypted? (assuming the person used the same password for both the vba project and the worksheet)
I need to unlock several worksheets and several hundred workbooks and the password has been typed in two different ways. One word is typed in a lower case,the other is mixed case.. same password. I found Smittys code that will unlock all of the worksheets but I need to modify it so it can unlock both formats.
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
Would I just add this line of code:
I want to change/reset VBA password for Access VBA projects from VBA code itself.
While googling, I found few code to unlock Excel VBA project but I was unable to modify them for access.
Basically I want to set/remove VBA password of one mdb file programatically from another mdb file. I'll be having the VBA password, so this is not for recovery purpose.
Thanks in advance.
Hi: We all know that we can protect our VBA Project Code from Viewing by checking the Protction Tab within VBA Project Properties and entering a password.
Question: In doing so, is a macro prevented from running without adding a line of code to unlock and lock the VBA Project Properties?
I have a portion of a macro that enters a checkmark to a Control Box Checkbox. The portion of said Macro ran fine until I locked the VBA Project Properties. Within the Macros, there is already a line of code to unlock the worksheet that is also password protected, but does one also have to unlock the VBA Project Properties in order to run a macro???
The first part of macro unlocks the sheet via:
However, the macros presents with error when asking a checkbox from the Control Toolbar to be checked when the VBA project Properties are locked vs working prior to locking the VBA Project Properties from viewing, The portion of the macro that ceases with a bug is:
For Each ctl In Worksheets("Sheet1").OLEObjects
If TypeOf ctl.Object Is MSForms.CheckBox Then
ctl.Object.Value = True
Help is appreciated: Unlock VBA project Properties vs a better way to have a macro check a checkbox?
Is it possible to have a macro unlock all of the worksheets in a workbook, each worksheet is password protected (they all use the same password). It would be nice when I am updating the protected cells that I can unlock all of the spreadsheets at once and then lock all of them when I am done.
I have more than 30 excel files and each file has macros locked for viewing. I used the same password to lock the VBA Project of all the files.
To modify the macro codes (or VBA components procedure and code modules) in all those files stored in a different directory, I have developed a macro procedure to automate the process. I run into error becos the macros to be modified in the files are password-protected in the VBAProject property.
How can I include the known password in my procedure so that I can first unlock the VBAproject before I modify the code modules in the remote files. Thanks.
Pwd = InputBox("Please enter Password to unlock the workbook.")
For Each ws In ActiveWorkbook.Worksheets
If Err 0 Then
MsgBox "You have entered an incorect password. All worksheets could not " & _
"be unprotected.", vbCritical, "Incorect Password"
On Error GoTo 0
I am using this code so that users can unlock all worksheets with a password.
when users click "cancel" or supply the incorrect password, the debugger comes up and I don't want users to go to the VBA code.
I need to modify the code so that when users enter the wrong password the routine just exits ...
i tried doing it with the code above but doesn't work.
could anyone help ?
I have one macro file which is password protected but I had missed out the password.....Can you please unlock the file for me.....If you want I can send the file to you as well...
Hello! I have addin containing several worksheets. The addin is an xlam file in excel 2007. Some of the worksheets contain vba codes (such as worksheet selection change event) in the sheet code module.The vba project of the add in is password protected. Some worksheets from the addin get copied to the current active workbook. The vba modules of addin can not be viewed because they are password protected. However the sheet codes of the copied worksheets from addin can be viewed. How can I password protect these worksheets codes?
So, I have my VBA project locked, and i still have the password,but for safety, i'd like to have a macro to unlock this password in case i forget it.
Is is possible?
I have a file created by someone who left the company and did not leave a password to unlock a protected sheet.
Is there a way to do this without a password?
It is a complex file, so I don't want to recreate it if I don't have to.
Can someone show me how I can unlock a range of sheets that are password protected in my workbook.
I have 20 identical sheets one for each department which are protected by the same password.
It would be nice if I could rapidly lock and unlock these sheets.
What I need a set rng command in conjunction with a For Next loop?
Thanks in advance.
I have protected some worksheets and have very stupidly forgotten the password. Is there a way that I can unlock the sheet without knowing the password. I can't be the first person to have done this....can I?
It is quite a complex sheet, is there a way that I can copy the data to a new workbook if it is not possible to unlock teh protection?
I've noticed that, on occasion when I protect the vba modules with a password, and copy the Excel workbook containing the password-protected modules, to a different computer, when I then try to unprotect the vba files I get a status message that says "Project is unviewable" with a dialog title that says "Project Locked". I am not presented with the password entry dialog box as usual so am unable to enter my password to unlock the vba code.
Why does this happen?
I have a project budget file consisting of a summary worksheet for all projects and separate project worksheets. One finance person enters budget allocations to and between the different projects on the summary worksheet (Budget Allocation Table), and project owners enter spends for their project on their specific project worksheet (Project ___ Budget Table). The Budget Allocation Table will be password protected and only finance will make edits.
I am trying to find a way to carry over data from the master 'Budget Allocation Table' to the individual 'Project ___ Budget Tables' for any line item that affects that specific Project Budget.
Assumptions: Budget allocation table will be managed by one person in finance and will be password protected Individual project budget sheets will each be on their own tab. All entries made ONLY in the budget allocation table. Project budget tables update automatically Individual project budget sheets need to 'scan' the budget allocation table and 'pick up' / 'repeat' any budget amount and note that applies to their budget. Macros/VBA are OK (although I am at them), file already has macros and is a .xlsm file type.
I've tried searching these forums, Excel help and on the web, but I'm mostly finding Vlookup type suggestions. I'm sure if I knew the 'name' of the feature that would work here, I would be well on my way to a solution.
Thank you in advance.
Would anyone be able to provide information on why I'm unable to save an Excel file when my VB project is password protected?
The message I receive is, "...You cannot save to this file format when the VBA Project is protected. You may unprotect the VBA project..."
The VB Editor is purposely locked (to not allow users the ability to modify code). It seems as though I have used many .xls files, where the VB Editor is password protected and I haven't had any issues saving the file.
Any ideas on what may be causing this?
Thanks in advance to everyone.
I recorded a macro for protecting my worksheet and included a password. The macro didn't have any reference to the password. Why would that be?
Also, I use the macro in a VBA module and add the phrase Password:="MyPassword". The page is protected but I can unlock it without the password.
I need a routine that will lock the page so users cannot unlock it without the password.
I have made an Execl file sometime ago and protected it with password.
I forgot my password!
Can I unlock the file without the password?
I found that the password in Excel to unlock worksheet or workbook is not
unique. That means I can use password B, C or D to unlock a worksheet or a
workbook that was locked with password A. Let me quote some examples:
Password Equivalent Unlock Passwords (just quote some for
1234 <-> 9080, 1480, 3580, ¡K
3456 <-> 9380, 7480, 5580, ¡K
I just tested it with MS Excel Xp SP2 / SP3. Not sure if this problem also
exists in other versions of Excel.
Perhaps the password authority is checked by certain non-one-to-one
calculations so that many inputs can result true. I also know that this can
minimize the risk of guest to find out the original password that may be
used in many other applications. However, this will also greatly increase
the possibility of guest to unlock the worksheet or workbook and do
Could anyone tell me whether it is a bug of Excel or it is by-design?
I have been sent a file to work upon..... it has a macro in it which i want to look at....
but when i try to open the vba project of this file a pop-up appears saying "project is unviewable".... it does not asks for any password also.....
I contacted the person who sent it to me and he said he never put any password to the vba project of the file .... he is also unable to see the project...
can anyone please tell me why I am getting this.... and how to open the project in vba....
how can it become unviewable when the creator did not put any kind of lock or protection to it... and had it be done the project should have atleast asked me to provide any password to view the codes..... please help...
A while ago I built a report template and had VBA protected with a password and now I can't find my notes which tells me what password i used.
I've searched the forums and a number of people say how easy it is to circumvent the vba protection but don't say how.
Can anyone give me any tips how to unlock this in some way without having to buy a password cracking tool?
Hey, just wondering if there's any way of making a VBA code to unlock a worksheet (preferably all of them in the file at the same time) that uses a cell to look for the password.
So the user just types a password in say A1 then clicks a button and it'll unlock the worksheet.
Thanks for any help.
I have a spreadsheet that is being used by a number of students to enter data that once entered, becomes protected so they can't edit or delete the data. Everything is perfectly set up, except that whenever you open the file, it asks for a password to unlock it. You can't enter data till you close the box, either by entering the password, or clicking cancel., but I would rather see if there is a way to stop the pop up at all, so the only way to unlock it is to click Unprotect Sheet and enter the password then. Any ideas? Also, is there any way I can lock out access to the macros so people can't edit them either? I want this thing to be locked solid.
I have the age old issue of a member of staff having created a password protected VBA project. This member of staff has now left the company and not unlocked the project. Therefore it's not possible to make changes to the code.
Is there some code I can use to extract the password?
Or is there a method of recovering the password that doesn't involve spending money on password-recovery software?
I need to password protect a VBA project. This is being done internally and the people with the password will be within the office. How do I do the protect. The worksheets will be password protected, but in order to perform sum of the operations the worksheets will be unprotected and then reprotected. We are trying to protect the password that will be in the documentation in the macro.