RoryOF wrote:Volunteers are very welcome:
Alexis_Wilke wrote:and my file is 103 sheets.
rudolfo wrote:Save it as .ods after deleting the modules with the macros.
- and MyDomainsinRankingFormat.ods macros
----- sheet 1, 2, and 3 (these I have all deleted)
Pity, I deleted them already. However, I haven't noticed a problem yet, maybe what I do doesn't need the macros.
What do you mean with the other two parts, "the Modules" and "the Standard directory", I can't find either of those in any menu?
And it's not under "Organize macros", in my installation (OO 4.1.4).
but ExportImages appears under "My" macros, not under "OO macros"...
-- My macros (which certainly aren't mine)
Do you mean, with the file open,
Tools
Macros
Organize Macros
OpenOffice Basic
> There I have already deleted everything under "My Macros", and left "OpenOffice Macros" untouched. And under the branch named with the document, there is one sub branch "Standard", and I also deleted everything there (in my case, sheet1, sheet2, ThisWorkbook).
Or do you mean in File Explorer,
C
ProgramFiles(x86)
OpenOffice4
presets
basic
Standard
> That's the only folder named "Standard" (I looked), and at the moment there are 3 files:
script.xlb
Module1.xba
dialog.xlb
Should I delete those 3? I doubt that's what you mean, because you write "Macros that was installed by the main installer are located in the Directory named "OpenOffice / LibreOffice Macros". Those macros are very important"
Just to clarify: I said I DID delete all macros there where you confirmed "Yes" it's the right place. Correct?
But it really really STILL shows "macros" warning when opening that ods document (spreadsheet file).
Thank you. Why did you now change your name from Tibor to Zizi64? Did I do sth wrong?
this forum software may even allow private messages
I am not smart enough with spreadsheets to see WHY/WHERE are macros.
I take I shall not send the file then, Zizi?
Either way, you have too much confidence in my skills: I could not under any circum stances make a macro in Excel, in no past life, no. And I doubt in my remaining short period here I will learn that. Cause I DO NO NEED MACROS in ods or excel either
MrProgrammer wrote:This may not be practical in your situation, but you can use the Edit > Sheet > Move/Copy dialog to copy (check that box) all of your sheets to a new spreadsheet. In "To Document" use "- new document -" for the first sheet and then use your new "Untitled N" document for the remaining sheets, if any. Save the new spreadsheet and close both spreadsheets (old and new). Open the new one. Is the annoying message gone? Does spreadsheet look OK? If so, rename old spreadsheet and keep it for a while as a backup. Rename old spreadsheet to the name the old one had, if desired.
This is the techinque for fixing the problem in Excel. Once any macro is created in an Excel file, the file is "poisoned" and appears to have macros in it even if they are all deleted. The only solution is to build a new file and copy the content from old to new.
Why did you now change your name from Tibor to Zizi64? Did I do sth wrong?
The ods now is 27kb as compared to before 20kb, suggesting that those earlier xls "macros" consumed negative space, so "poisened" xls is....?
Since I can't see in which cells some "macro" is hiding,
Now I suggest someone with authority does the correct thing: Delete the word "Solved" from this thread. The recommendation above does NOT solve it for everyone.
Users browsing this forum: No registered users and 18 guests