Button in OpenOffice Calc
Solved
ladrine0378
Posted messages
12
Status
Membre
-
clint jp -
clint jp -
Hello,
Here is my problem. I can create buttons in the OpenOffice Calc spreadsheet, but when it comes time to choose which macro to assign, I don’t know which one to choose. I am stuck on the "assign action" dialog box; at that moment I select "execute action" and click on "macro," but I don’t know what to choose from the list. I simply want the name of the button to appear in the cell I selected when I click on it.
Do you have clear and simple explanations to provide me, please?
Thank you in advance to everyone who can help me.
Configuration: Windows Vista / Firefox 3.6.8
Here is my problem. I can create buttons in the OpenOffice Calc spreadsheet, but when it comes time to choose which macro to assign, I don’t know which one to choose. I am stuck on the "assign action" dialog box; at that moment I select "execute action" and click on "macro," but I don’t know what to choose from the list. I simply want the name of the button to appear in the cell I selected when I click on it.
Do you have clear and simple explanations to provide me, please?
Thank you in advance to everyone who can help me.
Configuration: Windows Vista / Firefox 3.6.8
5 réponses
Hello,
I'm trying to create a budget management project using OpenOffice Calc with my basic knowledge of Excel.
In my table, I want to create a button that opens a calendar which would let me click on a date and have it displayed in a cell.
Do you know the procedure to follow?
Thanks in advance
Clint JP
I'm trying to create a budget management project using OpenOffice Calc with my basic knowledge of Excel.
In my table, I want to create a button that opens a calendar which would let me click on a date and have it displayed in a cell.
Do you know the procedure to follow?
Thanks in advance
Clint JP
Hello
Before choosing your macro, you need to create it, which you apparently haven't done.
If you want to retrieve the name of the button, it seems quite complicated to achieve that result: you define a name (for example zz with the button's name as the value) and then you enter =zz and the result is displayed.
--
Stay calm
Before choosing your macro, you need to create it, which you apparently haven't done.
If you want to retrieve the name of the button, it seems quite complicated to achieve that result: you define a name (for example zz with the button's name as the value) and then you enter =zz and the result is displayed.
--
Stay calm
Hello,
it's nice of you to reply and want to help me, but I'm just starting out so I'm struggling with everything.
Indeed, if I have to create my macros, I understand why it wasn't working!!!!
Anyway, I tried to create a macro but I'm stuck there too... I have a book that explains how to create a macro command, but from the start they ask me to perform all the actions to be recorded in the macro command before clicking the finish recording button, but I don't know what kind of actions I need to take.
Anyway, it's complicated. In any case, it's nice of you to try to help me, but given my weak knowledge, I think it's a lost cause.
it's nice of you to reply and want to help me, but I'm just starting out so I'm struggling with everything.
Indeed, if I have to create my macros, I understand why it wasn't working!!!!
Anyway, I tried to create a macro but I'm stuck there too... I have a book that explains how to create a macro command, but from the start they ask me to perform all the actions to be recorded in the macro command before clicking the finish recording button, but I don't know what kind of actions I need to take.
Anyway, it's complicated. In any case, it's nice of you to try to help me, but given my weak knowledge, I think it's a lost cause.
Hello,
but right now I don't know what kind of manipulations need to be done
Actually, you need to perform all the functions you would like the macro to automate next, either using the keyboard or the mouse. In your case, it will not be possible to create a macro that assigns the button's name to a selected cell, and you would need to manually code the lines of the macro, which requires knowing the syntax.
but right now I don't know what kind of manipulations need to be done
Actually, you need to perform all the functions you would like the macro to automate next, either using the keyboard or the mouse. In your case, it will not be possible to create a macro that assigns the button's name to a selected cell, and you would need to manually code the lines of the macro, which requires knowing the syntax.
All right!
so for a beginner, it’s almost impossible.
so I think I’m going to have someone else do this, we need to rethink the problem differently, I will do my document without a button.
Thanks anyway for helping me, without that I could have searched for a while.
Thanks and see you soon.
so for a beginner, it’s almost impossible.
so I think I’m going to have someone else do this, we need to rethink the problem differently, I will do my document without a button.
Thanks anyway for helping me, without that I could have searched for a while.
Thanks and see you soon.
Hello, what function (macro) do you want to associate with the buttons?
To create the button, with Open Office Calc or Writer, you need to display the Forms Control toolbar.
Then, if it's a button to press: you need to choose the Button icon.
With the mouse, you draw your button on your sheet.
For the next steps with your email, I can send you what I have done with simple macros.
A workbook with three sheets, buttons to open or close the sheets.
To create the button, with Open Office Calc or Writer, you need to display the Forms Control toolbar.
Then, if it's a button to press: you need to choose the Button icon.
With the mouse, you draw your button on your sheet.
For the next steps with your email, I can send you what I have done with simple macros.
A workbook with three sheets, buttons to open or close the sheets.