Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

Hi Ptoye and all:

        You can do the same process but more directly with : Menu-Tools-Customize

        I was using for this explanation: LO with English setting

        By the way, The Document Foundation organization, that is in charge to development LibreOffice, is needing voluntaries to update the documentation and help, to the new version: 6.0. If you want to contribute with this, you can e-mail to this list to Olivier Hallot to know more about this.


Jorge Rodríguez

El 03/03/2018 a las 05:09, ptoye escribió:
Firstly - sorry to all. I was getting extremely frustrated in trying to do
what looks like a simple thing, but obviously isn't.

I'm finding it a bit difficult to follow your instructions - I suspect that
you are using a different language (Spanish?) from myself.

In Step 2 there isn't a "All Commands" button - but there's an "Add command"
button - is this what you meant?

What you have suggested here - and many thanks for this - seems to be what I
found out by myself: add new buttons and remove the old ones. This is a very
long-winded way of going about it and I'm surprised that the designers
didn't think of  a more user-friendly way of reassigning. Your suggestion
implies that they didn't. I had assumed that I'd missed something simple.

I still think it would be a good thing if the help system mentioned this

jorge Rodríguez wrote
Hi Ptoye and all:

      At first, try to be more polite because almost all us are
volunteers and collaborate as we can and all of us try to do better.

      As I understand, you can reassign a macro following this steps (Or
solve your problem like this) :

1) Menu-Tools-Macros-Organize Macros-LibreOffice Basic (I use this
because is the only programming language that I've used to make a macro
and assign to a toolbar. I don't know if using other language is the
same to do it.)

2) Select Assign icon to open a Dialog Window. There select Toolbars and
click on "All Commands" option. Scroll down to find Macros and select it.

3) In the Chart Function, appear the places where your macros should be

4) Found what you need

5) Now, at right, you can see the Options bar (Default Standar), where
you can select whatever toolbar existing in LibreOffice Calc. But now,
select the + icon that it place at right of it.

6) Appear a Dialog Window where you can input a name ("MyTools" for
example), to make a new toolbar where you can assign all your Macros or
only some of them. Select too the place where it will be saved (Option

7) Now, select the macros that you previously found ( Chart Function
-point  4 ), and with the Arrow to right move to new toolbar "MyTools"
all the Macros that you want.

8) Click "Ok" and then Close the Window. In the area of the toolsbars
(Top of your spreadsheet), below the two first default bar, you can find
your new MyTools bar icons that each one run each macro assigned.

9) The last step is to eliminate the macros of the other toolbar where
you had assigned some of the macros and where you couldn't find place
for all of them. I hope you know how to do this to doesn't duplicate
icons in your spreadsheets (Two bar of them with some same icons that do
the same). If you had problem, can request again to the user e-mail list
of LibreOffice.

I hope this help,

Jorge Rodríguez

Sent from:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.