Microsoft Office Tutorials and References
In Depth Information
Figure 10-6. Add-in properties
Creating an add-in is a simple process. It begins with an Excel workbook, say SRXUtils.xls . (This
stands for Steven Roman's Excel Utilities.) The workbook, of course, contains a number of macros.
To create an add-in from the workbook, follow these steps:
Compile the project using Excel's VBA Editor.
When the code in any VBA procedure is edited and then executed, Excel must first
compile the code; that is, translate the code into a language that the computer can
understand. This is why there may be a slight delay the first time code is executed.
Subsequent execution of the same code does not require compilation unless the code has
been changed since the previous compilation. To compile the code in SRXUtils.xls , select
the Compile option from the Debug menu.
Set a few worksheet properties and a few project properties.
We should also set a few properties for the add-in. When SRXUtils.xls is the active
workbook in Excel, choose the Properties option from the Excel File menu and then
display the Summary tab, as shown in Figure 10-6 . The Title is the string that will be used
in the Add-Ins dialog, shown in Figure 10-7 . The Comments will be shown at the bottom
of the Add-Ins dialog. Therefore, you should fill in both of these sections in the Properties
dialog, as shown in Figure 10-6 .
Figure 10-6. Add-in properties
Figure 10-7. The Add-Ins dialog
Search JabSto ::

Custom Search