Page 1 of 1

[Solved] Can't password-protect my macro library

Posted: Wed Dec 20, 2023 5:07 am
by alf50
SOLVED- OO4.1.14 will not let me Password protect my Macro Library.

In earlier versions, I could create a library associated with my Calc Spread Sheet, debug the code, then before allowing others to use the application, I would go to the Basic Macro library, click on the Password Protect button add a password, retype the password and the Macro code was useable but protected from anyone else modifying it.

Now when I follow all those steps, then quit and Save the application, then reopen it, I can still view and modify the macros without ever being challenged for the password. when I go back to the Library password dialog, everything is again BLANK?

What is going on ? ? ?

Re: OO4.1.14 will not let me Password protect my Macro Library

Posted: Wed Dec 20, 2023 10:08 am
by Bidouille
For this to work, you must have a library named other than "Standard"

Re: OO4.1.14 will not let me Password protect my Macro Library

Posted: Wed Dec 20, 2023 6:34 pm
by alf50
Bidouille, or who ever else might try to respond to my request:

I might not have been clear enough in my original request, but I did create a new "Non-Standard" named Library when I started developing the application. That is why OpenOffice 4.1.14 provided the Password button in the first place. I have tried this on my Window10 Computer as well and I get the same result.

I am running on a Mac Mini, with OS X 10.15 operating system. Would someone else please try to Password protect a simple OO App while using OO4.1.14, create a "Non-Standard" named Macro Library and see if you can Password Protect that Library. I cannot distribute my application to Community Service Club Members until I get this inability to password Protect the Library solved.

THANK YOU in advance ! !

Re: OO4.1.14 will not let me Password protect my Macro Library

Posted: Wed Dec 20, 2023 7:29 pm
by Villeroy
Works for me after restarting the application. During the same session, the decrypted library remains editable.
The attached file has a macro Module1>Hello_World in encrypted library "Library1" with password "villeroy" created with AOO 4.1.14 under LInux.

Re: OO4.1.14 will not let me Password protect my Macro Library

Posted: Wed Dec 20, 2023 8:20 pm
by alf50
Villeroy,

The OO writer Macro Library you prepared is password protected and required me to enter your password before I could see the Macro Code.

BUT my OpenOffice Calc Macros remain unprotected. Could you generate a simple OpenOffice Calc Macro Library and protect it to see if you can duplicate the Unprotectable library if you are in the CALC application rather than the WRITER application. Maybe this is an APPLICATION SPECIFIC BUG in OpenOffice 4.1.14

Thanks again for your effort and help

Re: OO4.1.14 will not let me Password protect my Macro Library

Posted: Wed Dec 20, 2023 8:47 pm
by alf50
Villeroy,

Found the problem. I had two "Library1's", one in "MyMacos" area and one under my Program's area. I password protected the wrong one.

Sorry for bothering you.

Again, Thank you for your help ! !

Re: OO4.1.14 will not let me Password protect my Macro Library

Posted: Wed Dec 20, 2023 8:55 pm
by Villeroy
:super: :)