Chapter 29. Providing Help, Securing, Packaging, and Distributing

The final step in developing an Excel-based application is preparing it for release to our users. This includes creating a help file and incorporating it into our application, securing the application to prevent accidental or malicious changes, limiting access to features by checking the user’s network group memberships, and avoiding the display of the Macro Security warning dialogs. Finally, we need to decide on a mechanism for installing the application on our users’ computers. We might also want to include features within our application to easily deploy updates.

Providing Help

From the very start of a project we should be thinking about how to provide assistance to our users. ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.