Ask Your Question

Why do I have to enable macros in a digitally signed document every time I open it? [closed]

asked 2014-10-03 18:01:28 +0200

updated 2020-07-12 14:23:51 +0200

Alex Kemp gravatar image

Version: Build ID: 410m0(Build:2) Languange: en_US Component: calc OS: Linux Mint 16 (petra)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 18:20:51.596282


Do you have to answer the same question everytime or enable from a menu ?

rautamiekka gravatar imagerautamiekka ( 2014-10-03 18:55:39 +0200 )edit

Same question every time.

Hugh gravatar imageHugh ( 2014-10-15 22:19:33 +0200 )edit

Try updating your LO, cuz the area mentioned in my answer was buggy in some specific versions, gotten self-fixed later.

rautamiekka gravatar imagerautamiekka ( 2016-09-14 10:03:57 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-10-03 19:03:04 +0200

updated 2014-10-03 19:04:03 +0200

In settings, under LibreOffice, is Security, and it has Macro Security button. Set the level to Medium, and a tab for trusted sources. I think you can import or something the signature to LO by menu: File -> Digital Signatures.

edit flag offensive delete link more


This is not a solution that works for me. Macro security level had already been set to Medium, plus I had already digitally signed the macro in question, to no avail. I tried digitally signing the spreadsheet and that doesn't work either; I still must OK the enabling of macros every time I open the file.

Also, every time I change and save the document, the signatures are removed and I have to resign it.

Hugh gravatar imageHugh ( 2014-10-15 22:23:11 +0200 )edit

Can anyone tell me if this is the way it's supposed to work? Namely, 1. that I must OK the enabling of this macro every time I open the file, and 2. that I must resign the document every time I change the data and save the document?

Hugh gravatar imageHugh ( 2014-11-03 19:56:19 +0200 )edit

Question Tools



Asked: 2014-10-03 18:01:28 +0200

Seen: 1,876 times

Last updated: Oct 03 '14