Ask Your Question

How to save a document with macros while keeping macros disabled?

asked 2017-03-29 13:15:32 +0200

artfulrobot gravatar image

updated 2017-03-30 11:41:45 +0200


Answers and comments so far have focussed on the wrong part of my question, so I'm re-stating it here:

I wish to open a document that includes macros in it, but with macros disabled so they don't run, then I need to be able to save a copy of that document but including the macros.

It seems that opening the document with macros disabled means that while I can inspect (and manually run) macros, they are not saved when I save the document.


Original post:

I've been sent a document with a macro virus - probably - and it's password protected. I have the password.

I wanted to know what the virus was, so my plan was:

  1. Open the document in LO with macros disabled.
  2. Save the document from LO without a password
  3. try the now non-encrypted file with a virus scanner.

But whenever I save the document the macros (which I can see are there in the document) are gone. Is there a way to remove the password from the document, preserving the rest?

edit retag flag offensive close merge delete


Why don't you just throw the file away if you think there's a virus in it. That's what I would do!

LibreGuy gravatar imageLibreGuy ( 2017-03-29 14:49:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-03-30 06:27:17 +0200

EasyTrieve gravatar image

Humm, can you first disable the macro in your LO using this?

image description

image description

BUT, has it occurred to you that the macro might be the one asking for the password?

Sounds dangerous. Probably not a good idea to accept or run macros from unknown sources.

edit flag offensive delete link more


Thanks, but I do not wish to run the macro, which is what your instructions lead to, I just need to be able to save it when I re-save the file. Also, I can confirm it is not the macro that is asking for the password. (I've tried various things in a discardable VM sandbox OS without a network connection but to no avail.)

artfulrobot gravatar imageartfulrobot ( 2017-03-30 11:37:02 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-29 13:15:32 +0200

Seen: 197 times

Last updated: Mar 30 '17