OK, I"m investigating the use of Excel VBA macros directly by LO.
it appears that LO does not save any VBA Userforms when saving.
I happen to have both Excel and LO 6.3
Here’s what i did:
(following in EXCEL until noted)
- create a new EXCEL workbook
- record a short macro
- create a userform (userform1) with a listbox and a command button
- write code (in the macro) that takes the contents of cells A1 to A8 and ADDS them to the listbox, then SHOW the userform
- set the command button to HIDE the userform.
(end of macro)
Now open the file with Libreoffice. File opens fine. Running the macro (module under VBAProject) indeed shows the properly populated list box, and the command button works as intended.
UNTIL i SAVE the file.
Then the form goes away. appears it is not saved. re-opened the file with EXCEL and no form.
if i don’t save the file, i can open it multiple times in LO, it all works. Just once i SAVE the file, the userform is gone.
Am i doing something stupid?