Apache OpenOffice Community Forum

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!

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.

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

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

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...

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.