One-click macros

Q I have started to use Openoffice Calc instead of Excel, but I cannot work out how to create and add icons for macros to a toolbar. I use these to open spreadsheets.
Brian Collier

A This is possible with Openoffice Calc but it is not quite as easy to set up because it is not possible to right-click on a toolbar to customise it.

Left-click on the Tools menu and select Customize. Click on the Toolbars tab and then select which toolbar the macro should be added to in the Toolbar dropdown menu. Click on the New button to create a new Toolbar dedicated to the macros icon.

Click on the Add button in the Toolbar Content section of the window. Scroll down in the Category list on the left-hand side of the window that appears to the bottom option, Openoffice.org Macros, and click on the small plus button.

Click on the small plus to find the macro. If you accepted the default settings when creating the macro this will be in My Macros, then Standard.

Click on Module1 and the macros will be displayed in the right-hand column. Left-click on the one wanted for the toolbar and then on Add. You can select another macro to be added or click on the Close button.

The Macro will now be shown in the Commands list in that toolbar. There is no icon at the moment, just the name of the Macro.

Click on the Modify button and then Change Icon. Left-click on an icon to select it and click on OK.

Alternatively click on the Modify button and then Rename to give a better name for the toolbar. The up and down arrows are used to change the position of the icon in the toolbar. Click on the OK button when you are happy with the changes.