Chapter 24. 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 adding code to display it from our application, securing the application to prevent accidental and/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 upon a mechanism for installing the application on our users' machines. We might also want to include features within our application to easily deploy updates.

Providing Help

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

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® 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.