You may, of course, decide that you prefer to provide an easy way of running macros. If that's the case, then you might consider adding the macros to OpenOffice.org Calc menus.
We've seen that a macro can be run as soon as you open a spreadsheet, but that's only good for a single macro. However, if you want control of a number of macros, then you can add the macro to one of OpenOffice.org Calc's menus. Even better you can add a completely new menu.
Again you need to click on Tools | Customize...; however, this time you'll need the Menus tab, then use the New..; button to open the New Menu dialog :
Once you've created your new menu (by pressing OK), you ...