These pages are no longer updated and are only available for archive purposes.
Create an addin in Excel5/95
Describe the contents of the addin workbook
The statusbar can display a description text that informs the user what task the menu
will perform when the user selects a menuitem. This can be done by filling in information in
the field for statusbar text when you have the dialog Macrooptions
Worksheetfunctions in addin workbooks will be displayed in the Function-Wizard under the category Userdefined if nothing else is applied for the macro options. Ordinary macro procedures should be started by a menu or a toolbarbutton. The use of shortcut-keys is not recommended. It's not always easy for a user to guess which keys to press to perform a task using the addin. Custom shortcut-keys will often come in conflict with the built-in shortcut-keys in Excel or any other custom shortcut-keys already assigned by the user. And the fact that you never use that shortcut-key is no guarantee that all the other's don't.
Saving the addin workbook
When you are ready to create the addin, remember to save the original workbook. It's (usually) not possible to make changes to an addin. So if you want to make changes later to the addin, you will have to use the original workbook that created the addin to make the changes in, and then create a new addin.
Here is how you create the addin :
The new addin workbook is now saved and ready to be installed.
Document last updated 1999-04-15 12:46:25 Printerfriendly version