How to unlock a locked VBA project?
Posted by Keefas on January 09, 2002 12:50 AM
I´m trying to unlock a locked VBA project. I have the password, but where do I insert it? I can´t get to the project properties window cause the project is locked! I know that in there would be the protection tab, but how to get there?
Posted by Tom Urtis on January 09, 2002 1:22 AM
Press Alt+F11 to get into the Visual Basic Editor. In the left vertical pane is the VBA Project Explorer window, listing the current open projects. If you do not see this window, then while in the VBE press Ctrl+R. Your open workbook is a project, and will be listed in that pane, probably as the last entry. Double-click that that project name (it will be in the syntax VBAProject (YourFileName.xls), and a dialog box will pop up, prompting you to enter the passcode.
Note, once you close the file it will re-open the next time locked again. To unlock it, click on Tools > VBA Project Properties, choose the Protection tab, deselect the "Lock project for viewing" box, and clear the two password fields.
To return to the worksheets, close out of the VBE by clicking on the X in the upper right corner, or by pressing Alt+Q.
Tom Urtis
Posted by Keefas on January 09, 2002 1:52 AM
Doesn´t work...
Posted by Ivan F Moala on January 09, 2002 2:01 AM
Re: Doesn´t work...
Posted by Keefas on January 09, 2002 3:09 AM
Still doesn´t work...
Posted by NiuB on January 09, 2002 4:26 AM
Re: Still doesn´t work...I know why this this happened!!=>
