Macro stopped working after closing/reopening document

English
#1

LibreOfficeVersion: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.6
OS: Kubuntu 20.04

I recorded a macro in Calc and used it many times with great success. I closed the document for whatever reason.

When I re-opened the document I saw a security warning pop-up about Macros being risky. The pop-up said something like “this file will open but only after disabling macros for safety”.

I went straight to settings and turned Macro Security to LOW.

Now, nothing happens when I attempt to run the macro. Please advise.

#2

I closed and re-opened the document. Now the macro works great again. : )

#4

Nevertheless.
See below: Never set LOW macro security .

#3

NEVER do so! It’s too risky.
Either use MEDIUM, and permit on prompt if sure you know that the contained macros don’t have malign functionality.
Or save the documents containing the few macros you use only in documents they are made for to a special folder which you add to
Trusted sources >> Trusted file locations
Macros you want to use with different documents you should anyway create in modules of the Standard library of the application:
My Macros & Dialogs / Standard in the left panel of the IDE.

A document already loaded without permission for document macros must be loaded anew before a changed persmission applies. .

1 Like

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