Analytical Dynamics VBA IDE Macro Editor

One of the most basic security moves you can make in Microsoft Office is to uncheck the Trust Access To Visual Basic Project checkbox in the security dialog. This goes a long way toward protecting you against simple macro viruses. Unfortunately, it also stops you from running utility VBA programs against the VBIDE object model. This add-in (for the IDE, not for Excel) addresses that issue by providing the IDE with its own VBScript Macro Editor that executes macros directly against the VB Editor, thus bypassing the security setting. I use it for adding standard code blocks, scanning projects and doing simple housekeeping tasks - all of these are simply configurable by tweaking the VBScript code.

The background to this add-in is that it was originally written as an add-in for VB6. The help file has not been updated form the VB6 version, so you'll have to use your imagination a bit.

This is distributed as GuiltWare. Please don't use it in a commercial way outside of your immediate job function.

Click here to agree to this restriction and to download the setup files (zipped, about 2 Mb).