On 02/08/07, F Goodchild <[EMAIL PROTECTED]> wrote: > > Good morning > I am using openoffice2 .2 on a mac powerbook G4 - standard processor > not intel with mac OSx.4 > > I have used excel for some time and am used to writing and running > macros in that environment but am having some difficulties learning > to do this in calc > > 1. Is there a way to put the macro command from the TOOLS menu into > the Standard toolbar. I have tried customising the toolbar but the > only options under 'add' appear to be the ones for that menu. > this is something I did in the dreaded excel and I would like to be > able to do it in calc.
I don't know if this will work on your Mac system but it works for me on Windows XP Pro: View>Toolbars>Customise>Toolbars>Standard as you've already done Click Add In the Category (left hand) pane select BASIC In the Commands (right hand pane) select Run Macro or whichever one(s) you like (one at a time) Click Add You can position them with the clickable up/down arrows. If you want to add individual macros you can do that too: View>Toolbars>Customise>Toolbars>Standard as you've already done Click Add In the Category (left hand) pane click the little + sign against (="expand") OpenOffice.org Macros and keep expanding the "folders" till there are no more little + signs. At this point a list of macros will appear in the right hand pane. In the Commands (right hand pane) select the macros you want (one at a time) and click Add. Again, you can move them with the clickable arrows. The name of the macro will appear in the toolbar. <snip> regards > > Frances > London > Don't know about #2; hopefully someone else will respond. I do know that the recorder is fairly elementary and doesn't record anywhere near everything. There is quite a lot of documentation about and examples of macros. For example: http://www.ooomacros.org/ http://www.pitonyak.org/oo.php http://www.pitonyak.org/book http://www.tutorialsforopenoffice.org/tutorial/Macros.html and, last but not least, follow your nose from http://documentation.openoffice.org/ -- Harold Fuchs London, England Please reply *only* to [email protected]
