Dear specialists, I have a small problem with a Calc file in which I have a number of embedded macros that suddenly all disappeared. I use. Where are these macros stored? Does anyone know how to restore this, my thanks will be enormous for your help. I think it is important to mention that I use Libre Office portable.
It is also important to tell which version of LibreOffice you use. Go to Help |about LibreOffice, use the icon next to Version Information to copy the info and then edit your question and paste there. Mention also your operating system
1 Like
Ola @1e_skip , as macros estĂŁo salvas no arquivo?
Se SIM, e salvar o arquivo em Excel, as macros sĂŁo perdidas.
Hi @1e_skip, are the macros saved in the file?
If YES, and you save the file in Excel, the macros are lost.
1 Like
Thanks for the quick response. And I’ll add that right away.
Version: 24.2. 0. 3 (x86) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL threaded
Thank you too for your quick response and as you can see I had already written that the macros are embedded in the calc file. So stored in the file itself. And for clarity, not in Excel, but in Libre Office calc.
What @schiavinatto meant was “if you create macros in a spreadsheet document, and save that document as an Excel file type - like XLSX - then your macros may be lost”.
So - perhaps the most important missing bit of data is which file format you use to store your documents.
2 Likes
Ok in that way. yes it was indeed a xlsx file but because the buttons disappeared every time I had saved it as ODS in the hope to solve this problem. and after that the macros disappeared. but the strange thing is that when I open the original file the macro is also still gone.
No arquivo ods, refaça as macros em Basic, e salve o arquivo.
In the ods file, redo the macros in Basic, and save the file.
I want to thank everyone for the responses