Unlock Vba Project

For Each ctl In Worksheets("Sheet1").OLEObjects
If TypeOf ctl.Object Is MSForms.CheckBox Then
ctl.Object.Value = True
End If
Next

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.

Code:

Pwd = InputBox("Please enter Password to unlock the workbook.")

For Each ws In ActiveWorkbook.Worksheets
ws.Unprotect Password:=Pwd
If Err  0 Then
        MsgBox "You have entered an incorect password. All worksheets could not " & _
        "be unprotected.", vbCritical, "Incorect Password"
    End If
    On Error GoTo 0

Next ws

End If

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 ?

Hello Team,
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.

Thanks,
Jim

Hi Guys,

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?

Thanks,

Stu

Excel 2010
Windows Vista

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.
Alex

Hello Everyone,

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.

Hello,
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?
Thanks,
Gilamg.

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
reference)
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
something unexpectedly.

Could anyone tell me whether it is a bug of Excel or it is by-design?

Best regards,
Danny

Hi,

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...



Regards,
Premanshu.

Hi All,

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?

thanks

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?

Thanks
Oliver

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.