[Solved] Edit Macro Button

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
Math
Posts: 89
Joined: Mon Oct 29, 2018 6:32 pm

[Solved] Edit Macro Button

Post by Math »

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.
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
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Edit Macro Button

Post by FJCC »

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.
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.
Post Reply