OpenOffice and buttons

[TechGate]

Hello,
I am facing a small problem for which various research on the net does not allow me to find a solution. We share on a LAN, an excel file (. Xls) that contains VBA macros activated by buttons. Users enter their data sheets to document and record their changes. Once a month, the secretary clicks a button on one sheet of paper, and the program then generates a result (as another excel table). The problem is that when the file is completed and then saved as openoffice (still. Xls), registration makes the buttons permanently inactive when then opens the document in Excel. The VBA code is present in the document. Xls, but we must "re-associate" the VBA code with the buttons (in Excel, of course) I am not trying to make functional macros in openoffice (the code is different), but simply that the registration does not break my macros. Macros are designed to operate only on a station equipped to excel. Porting OOo as is done later if needed. Clearly, I seek to have the following behavior: I change my data in OOo, I record, then the secretary starts processing from its excel by clicking the appropriate button. Has anyone already encountered and solved this problem?

[NetworkeR]

Hello,
It seems that when you open an Excel file containing the code in Open Office, it makes the code review (REM), and may he rest in comment then when you reopen it in Excel. It's just a hypothesis, I can see, I have no Open Office in TAF, but I have at home with MS Office. I hope you understand the point.

[Gunner 1]

Hello,
Even i am having the same problem, I am not persuaded that this is the right explanation, or at least that is the entire explanation of the phenomenon, because the button is completely frozen, it sinks more. If the code was merely in REM, the button would sink with no results. There, it penetrates more. To restore the program, I must delete button (in Excel), to recreate another and magic code to re-associate all alone in the new button I just created. I understand nothing, but it works like that.

[TechGate]

Hello,
I assume that indeed the novel version handles this a little better but the file turns on a set of machines that I do not run. A test in NeoOffice (Mac) shows that the button works and the code can be executed in part, to error on an instruction inconsistent with openoffice (normal).
But the record: same result.
Since the code is found and executed, I wonder:
1. which may prevent him from properly record in NeoOffice (the answer can perhaps give an initial response to my initial problem, who knows?)
2. why the behavior is not even his OOo and neoo

[SoftWore]

Hello,
It is best just being to separate the data of your macros, a little Excel macro-well act on the leaves of another workbook. then directs you to a "workbook data" for your "user" and "Macro Workbook" for your secretaries. Hope you are getting the point and you will do it. If you need any more help regarding this then please do post back.

[TechGate]

Hello,
It "directs you to a" workbook data "for your" user "and" Macro Workbook "for your secretaries." This is actually the easiest to implement. It crossed my mind but I wanted to know if someone had succeeded where I can not get out. Since this is not the case, so I'll do it this way: a document data and document macros that will get them in the table data. By the way thanks for you reply and if you have any more information on this then I am the interested one.