One method of distributing a finished VBA customization is to copy the VBA project file to the destination machine. The primary reason to use this method is when you have created an extensive VBA project that contains proprietary code you don’t want others to see. You can lock the VBA project before you distribute it, preventing others from examining your code. Do this by viewing the properties for the project and displaying the Protection tab.
There are disadvantages to locking a VBA project:
Also, distributing an entire VBA project doesn’t allow you to package any modified forms or modified reports that may be part of your customization. For all these reasons, we recommend that you use package files to distribute your VBA customizations.