Greetings,
I have several Macros buttons in a worksheet. I would like to edit or show the macro of a determinadon button that I choose.
I need this help to modify or change the Macro of a particular button that I want. For this I need to Edit the Button Macro.
How do I Edit the Button Macro?
thank you very much.
[Solved] Edit Macro Button
[Solved] Edit Macro Button
Last edited by Math on Tue Nov 06, 2018 7:38 pm, edited 1 time in total.
LibreOffice 5.4.4.2 on Windows 7
Re: Edit Macro Button
You do not need to Edit the button that calls a macro in order to change the macro.
To edit a button:
Select the menu View -> Toolbars -> Form Controls
A small toolbar will appear. The right hand button in the top row shows a pencil, a ruler and a drawing triangle. Click it to activate design mode.
Right click on the button and select Control.
To Edit a macro:
Choose the menu Tools -> Macros -> Organize Macros -> OpenOffice Basic.
From that dialog you can select the macro and then click the Edit button.
To edit a button:
Select the menu View -> Toolbars -> Form Controls
A small toolbar will appear. The right hand button in the top row shows a pencil, a ruler and a drawing triangle. Click it to activate design mode.
Right click on the button and select Control.
To Edit a macro:
Choose the menu Tools -> Macros -> Organize Macros -> OpenOffice Basic.
From that dialog you can select the macro and then click the Edit button.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.