[Solved] Hide macro code

Creating a macro - Writing a Script - Using the API
Post Reply
grnhorn
Posts: 32
Joined: Sun Jul 13, 2008 2:07 pm

[Solved] Hide macro code

Post by grnhorn »

In VBA it is possible to prevent a user from viewing the code with a password, is this possible in OO?

thanks...
Last edited by grnhorn on Wed Jul 23, 2008 11:53 am, edited 1 time in total.
OOo 2.4.X on Ms Windows XP
User avatar
squenson
Volunteer
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Hide macro code

Post by squenson »

You first have to create a new library, as you cannot password protect the default library called Standard. CLick on Tools > Macro > Organize Macros > Open Office.org macro. Then click the button "Organizer", then select the tab "Libraries", choose your document in the combo box. Finally (not quite!), click on the New button, type a library name and OK. You can now click on the button password to protect your library.
LibreOffice 4.2.3.3. on Ubuntu 14.04
grnhorn
Posts: 32
Joined: Sun Jul 13, 2008 2:07 pm

Re: Hide macro code

Post by grnhorn »

Thanks squenson, it worked as advertised.
OOo 2.4.X on Ms Windows XP
Maraujo
Posts: 1
Joined: Mon May 11, 2009 5:17 pm

Re: [Solved] Hide macro code

Post by Maraujo »

Hi All,

I protected my library (where all the macros are) with a password but i (or any user) can still see/access all the code just by clicking "tools->macros->organizer macros->OO Basic->(Select Macro)->Edit"
There are no dialogs asking for the password or anything to prevent macro edition

The user should not be able to see the macro code.

Am i missing something??

Cheers,
Mark
OOo 3.0.X on Ms Windows XP
User avatar
squenson
Volunteer
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: [Solved] Hide macro code

Post by squenson »

Have you exactly followed the steps of my first anwser?
Have you saved and closed your document, then re-opened it?
LibreOffice 4.2.3.3. on Ubuntu 14.04
Post Reply