On 2 Aug 2007, at 12:15, Harold Fuchs wrote:
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.
That works great
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.
Noted that just leaves problem 2 ie opening a .csv with a MAC
<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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
