Excel Visual Basic applications aren’t compiled in the conventional sense. Instead, the code is saved in the file and it is interpreted at runtime. In the old days, before viruses and security concerns, you could just save an Excel workbook and then distribute it to your users without a second thought. Now, you need to take additional steps to make sure your users will be able to trust the code you send them:
Protect your code to prevent users from seeing or changing it.
Digitally sign the files and provide instructions on setting macro security to allow the application to run.
Create an installation program to copy the files to the user’s system.
The following sections describe these steps in more detail.