Zizi64 wrote:What do you mean by "old Macro"? Where you stored that macro? In a file or in the MyMacros?
If the answer is "in a file", the please upload a problematic Base file here.
sub yoursubname()
end sub
sub yoursubname()
' line of code
' line of code
end sub
sub yoursubname()
Exit sub
'nothing else will run
end sub
JeJe wrote:Have you looked through your other libraries and modules to see if you can find somewhere within a sub which calls the macro?
One option would be to reinstate the macro but with nothing in it - it will be called and will run successfully but nothing will happen. eg
- Code: Select all Expand viewCollapse view
sub yoursubname()
end sub
You can also comment out a macro so nothing runs with ' in front of every line
- Code: Select all Expand viewCollapse view
sub yoursubname()
' line of code
' line of code
end sub
or put exit sub or exit function if its a function at the start
- Code: Select all Expand viewCollapse view
sub yoursubname()
Exit sub
'nothing else will run
end sub
JeJe wrote:Have you gone to Tools menu/Customise/Events tab and checked there are no macros assigned there - either to save in LibreOffice or save in your document options?
The name of the Library is still there below the Standard Library.
RoryOF wrote:If you know the name of the macro, you could search through the OO User Profile directory, using the computer search, for any file containing the macro name in its content.
There are no script files, but a directory exists.Villeroy wrote:There is no Python or any other code embedded. I save a copy in a non-trusted filder, open the copy, get the macro warning. I call the macro organizer, delete Standard.Module1, and the entire "MyLib". The Basic code is no longer visible. I save and close the document. When I open the document again, I get the same macro warning even though the macro organizer does not show any macros and there is no Basic folder nor any Scripts folder in the zip.
Downloads 561 $ cd ~/Downloads
Downloads 562 $ file=Konten.odb
Downloads 563 $ pdir=Scripts/python
Downloads 564 $ unzip -l "$file"
Archive: Konten.odb
Length Date Time Name
--------- ---------- ----- ----
39 06-03-2020 12:14 mimetype
47403 06-03-2020 12:14 settings.xml
23499 06-03-2020 12:14 content.xml
0 06-03-2020 12:14 Scripts/python/
0 06-03-2020 12:14 reports/
0 06-03-2020 12:14 Configurations2/menubar/
0 06-03-2020 12:14 Configurations2/toolpanel/
0 06-03-2020 12:14 Configurations2/floater/
0 06-03-2020 12:14 Configurations2/images/Bitmaps/
0 06-03-2020 12:14 Configurations2/toolbar/
0 06-03-2020 12:14 Configurations2/statusbar/
0 06-03-2020 12:14 Configurations2/accelerator/
0 06-03-2020 12:14 Configurations2/progressbar/
0 06-03-2020 12:14 Configurations2/popupmenu/
0 06-03-2020 12:14 forms/
884 06-03-2020 12:14 META-INF/manifest.xml
--------- -------
71825 16 files
Downloads 565 $ # Remove Scripts/python directory of ZIP file, if empty
Downloads 566 $ unzip -l "$file" "$pdir/?*" || zip -d "$file" "$pdir/"
Archive: Konten.odb
Length Date Time Name
--------- ---------- ----- ----
--------- -------
0 0 files
deleting: Scripts/python/
Users browsing this forum: Zizi64 and 6 guests