A more robust way to protect your VBA code is to convert the database to an. However, itâs a good way to keep people from accidentally changing the code. That’s it, everything should now be in order. Note that there are a lot of free or inexpensive tools that allow you to ârecoverâ lost passwords, so protecting your VBA by using this procedure should not be considered a fool-proof security method. Enter a new password and confirm it to resecure the VBA Project with a known password. Next time you go to view the VBA code, youâll be prompted for the password. Click OK, and then close and reopen the database. Applying a Password to Microsoft Access VBA Code In the database that you want to secure the VBA code go to Tools Macro Visual Basic Editor or press Alt +.On the Protection tab, select the Lock project for viewing check box.On the Tools menu, select Propertiesâ¦.In Access, press ALT+F11 to open the VBA editor.

A question came in recently regarding whether you can password protect just the VBA code for an Access database, but not the rest of the database.

Ms access password protect vba code