Microsoft Office Tutorials and References
In Depth Information
To remove all the breakpoints in all of the open projects, choose Debug
Breakpoints, or press Control+Shift+F9.
If you create some custom functions that you use frequently, you may want to store these
functions in an add-in file. A primary advantage to this is that you can use the functions in formulas in
any workbook without a filename qualifier.
Assume that you have a custom function named ZAPSPACES and that it’s stored in Myfuncs.
xlsm . To use this function in a formula in a workbook other than Myfuncs.xlsm , you need to
enter the following formula:
If you create an add-in from Myfuncs.xlsm and the add-in is loaded, you can omit the file
reference and enter a formula like the following:
Creating an add-in from a workbook is simple. The following steps describe how to create an
add-in from a normal workbook file:
1. Develop your functions, and make sure that they work properly.
2. Activate the VB Editor and select the workbook in the Project window. Choose Tools
xxx Properties and click the Protection tab (where xxx corresponds to the name of your
project). Select the Lock Project for Viewing check box and enter a password (twice).
You need to do this step only if you want to prevent others from viewing or modifying
your macros or custom dialog boxes.
3. Reactivate Excel. Choose File
Show Document Panel, and Excel
displays its Document Properties panel above the Formula bar. Enter a brief, descriptive title
in the Title field and a longer description in the Comments field.
This step is not required, but it makes the add-in easier to use by displaying descriptive
text in the Add-Ins dialog box.
4. Choose File