![]() If you are prompted for a password, then your VBA project is locked. ![]() Excel VBA Macro- Locking cells after data entry. Rejected B After Selecting any of the above, that particular cell should be. If it opens, your VBA project is not locked. A Need two options in J8 till end (downwards) - Combobox 1. HOWEVER, if it is all shown as collapsed inside the main VBA Project group (with a +sign next to it) then click the + sign to open it. If you see any of these items right away, then your VBA project is not locked. If the main project group is already shown as open, you will see inside that group "Microsoft Access Class Objects" and "Modules" if any modules have been added. It is displayed in a hierarchy type format (with little + and - signs) but all of it is contained within the main project group for your database. Once you see the Project Explorer Sub Window, you should see the VBA Project associated woith your database. If you do not see that, then click VIEW>PROJECT EXPLORER We will also show you how you may be able to gain access to the VBA code inside the locked project. This article presents the 2 main reasons behind this message. ![]() Now, in the upper left area of the VBE Window, you should see a "Project" sub window. While in Visual Basic Editor (VBE), you click on a VBA project and receive the 'Project is unviewable' error, instead of a password input prompt. If you click that button, it will open the Visual Basic Editor Window. Inside that tab, there should be a button called "Visual Basic". At the top of the Access 2010 window, you should see a tab on the ribbon called "Database Tools".
0 Comments
Leave a Reply. |