O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Deploy

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:

  1. Protect your code to prevent users from seeing or changing it.

  2. Digitally sign the files and provide instructions on setting macro security to allow the application to run.

  3. Create an installation program to copy the files to the user’s system.

The following sections describe these steps in more detail.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required