O'Reilly logo

Learn OpenOffice.org Spreadsheet Macro Programming by Dr. Mark Alexander Bain

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Macros to the OpenOffice.org Calc Menu

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.

Adding a Macro to the Menu Manually

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required