Page 1 of 1

Writer – Sharing Macro Template Document?

PostPosted: Tue Aug 29, 2017 2:03 am
by REH-CAE-RPT
What's the simplest way to have multiple users accessing a centrally located read-only document that contains macros they can apply individually?

I've attempted saving as an .odt and .ott document, but apparently this doesn't maintain any of the macros I'd saved within the original file. (I'd been saving any macros within what I believe is the default location, My Macros > Standard > Module1, which I now realize is potentially the issue...)

With Word, I can save as a .docm (Word Macro-Enabled Template) file and set to Read Only. Any modifications I make are then immediately usable by all. That's basically what I'm hoping to replicate.

Also, is the Alt + F11 "Edit Macros" function the easiest way to select and run macros, if any macros we use are going to be based in the same location? Can I create a menu icon for that function? (Alt + F8 is "Run Macros", but you have to expand the Library section each time you open it.)

Thanks!

Re: Writer – Sharing Macro Template Document?

PostPosted: Tue Aug 29, 2017 7:06 am
by Zizi64
I've attempted saving as an .odt and .ott document, but apparently this doesn't maintain any of the macros I'd saved within the original file. (I'd been saving any macros within what I believe is the default location, My Macros > Standard > Module1, which I now realize is potentially the issue...)


You MUST store the macros into the document if you want share it with the document.

Shared macros.png



...And you (or the users) need to enable the macro running from a file:

Tools - Options - Open/LibreOffice - Security - Macro security - Medium.

Re: Writer – Sharing Macro Template Document?

PostPosted: Tue Aug 29, 2017 10:01 am
by REH-CAE-RPT
Understood and applied. Thanks.

Does it matter if I save as a .odt or .ott file?

Any suggestions for a shortcut key or icon? Even with the Alt + F11 "Edit Macros" function, I'd have to expand the "Macro From" folders each time I open it, which guarantees they won't be used, in my experience...

Re: Writer – Sharing Macro Template Document?

PostPosted: Tue Aug 29, 2017 10:35 am
by Zizi64
Does it matter if I save as a .odt or .ott file?


It is harder to rewrite the original .ott file accidentally, but it is so easy to rewrite an .odt file. The .ott files will lost the original URL at opening.