Writer: What Macros

English
,
#1

I have a document which always gives me a Macro warning when I open it.

The thing is, as far as I can tell, there are no macros. It may have had some a long time ago, and it was attached to a template with macros a long time ago, but I can’t find any evidence of any current macros.

I have checked everything available in the Tools Macro item, both organising and editing, and cannot find anything to delete.

How do I find and delete these mysterious macros?

Using MacOS , LO 6.2.0.3

html101-blank.odt

Calc thinks a file has macros but it doesn't
Macro warning shows despite no macros contained in document
#2

Can you create a copy, remove all text and upload the blank file still showing the macro warning?

#3

Sorry I missed your comment.

I have created a blank version of the document, and the Macro warning still appears.

How do I upload the file?

#4

Edit your original question and upload a file using the clip icon. Are you using MacOS Mojave? Allow me one remark regarading LO 6.2.0.3. This was the very first 6.2 release and I really do not recommend to use this version any longer. For my taste it had too many bugs.

#5

I have uploaded the blank document now.
As regards your comments on versions, yes, I am using Mojave, and I was using LO 6.2.0.3. I have now updated to 6.2.3.2, if that is any better? Maybe it won’t crash quite so often.

#6

Hello Mark,

thanks for uploading the test file. The issue with your file is, that there is an empty library called “Project” and this causes the macro warning. To get rid of this library and in consequence to avoid the macro warning, you need to perform the following actions (I’ve renamed the file for the following screenshots to MacroIncludedMyCopy.odt)

  • Open the file
  • Go to Tools -> Macros -> Organize Macros -> LibreOffice Basic and select your file in Macro From (You’ll notice 2 libraries called “Project” and “Standard”)

image description
image description577×509 17.9 KB

  • Click on button Organizer and select tab Libraries
  • Select your file in the dropdown called Location (existing 2 Libraries show up)

image description

  • Select library “Project” and click buttons Delete and Close
  • Click button Close on the returning dialog
  • Save your file

Hope that help - if yes, please click the check mark ✓ next to the answer.

#7

You know, I looked everywhere for that, but I never dug down deeply enough. Thanks so much for your work and your answer.

#8

Please click the check mark ✓ next to the answer to demonstrate that your problem has been solved - thanks in advance.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.