Page 1 of 1

[Solved] Macro to Toggle Sheet Protection

Posted: Thu Sep 28, 2017 12:40 am
by daveg7
I'd like it to not allow viewing locked text.

Thanks!

Re: Macro to Toggle Sheet Protection

Posted: Thu Sep 28, 2017 12:51 am
by Villeroy
Enough is enough. You can not ask for another code snippet every hour. We are no human macro recorders.

Re: Macro to Toggle Sheet Protection

Posted: Thu Sep 28, 2017 7:35 am
by Zizi64

Macro to Toggle Sheet Protection

I'd like it to not allow viewing locked text.
Thanks!
Please
- search in this Forum - viewtopic.php?f=9&t=73949&p=334075
- search on the web - http://ooo-forums.apache.org/en/forum/v ... 20&t=78225
- read Andrew Pitonyak's free macro books - http://www.pitonyak.org/oo.php
- study the API (Application Programming Interface) desctiptions - http://www.openoffice.org/api/
- download, install and USE an object inspection tool - like the MRI or the XrayTool if you want create (WRITE) macros (you can find them in this forum)
- upload YOUR code what YOU TRIED to create - we will examine it andthen maybe we can give you help to fix it.

Re: Macro to Toggle Sheet Protection

Posted: Fri Sep 29, 2017 2:24 am
by daveg7
Villeroy wrote:Enough is enough. You can not ask for another code snippet every hour. We are no human macro recorders.
My apologies. I didn't realize I was abusing the system. (I'm doing exactly one spreadsheet to help out a personal friend who is doing a beautiful nonprofit project, and I know I'll never make the time to learn these languages or syntaxes, though it does looks interesting.)

Thank you for all your kindnesses and the huge help I've already received.

David G.

Re: [Solved, kind of] Macro to Toggle Sheet Protection

Posted: Fri Sep 29, 2017 8:20 am
by Zizi64
and I know I'll never make the time to learn these languages or syntaxes, though it does looks interesting.)
:crazy:

...And your friend can not ask?
(There are localized Forums for many languages: https://forum.openoffice.org/)

Re: [Solved, kind of] Macro to Toggle Sheet Protection

Posted: Fri Sep 29, 2017 8:27 am
by daveg7
My friend is the "client," and she's depending on me. I keep telling her I don't know OpenOffice basic. She knows a lot less. In fact, she's no techie at all, and I'm the only one available to her.

I do have some experience with Excel VBA, but she wants everything free and knows I can't say no to her. Also, her project is worth my support.

;)

Thanks for asking. I wish I were in Budapest right now, but the Berkeley, California coffee shops aren't too bad, and some of them have sidewalk tables.

Re: [Solved, kind of] Macro to Toggle Sheet Protection

Posted: Fri Sep 29, 2017 8:40 am
by Zizi64
I don't know OpenOffice basic. She knows a lot less.
It will be a "long time project..." :D :bravo:

But: you must study the API (Application Programming Interface) functions, and not the very simple OpenOffice Basic (StarBasic) IDE and the StarBasic programming language...
That is the difference:
The MS VBA is a programming language and an IDE and a function library in one.
The AOO/LO StarBasic is a programming language and it has an IDE too, but the functions for controlling of the opensource office suite (the API functions) are independent from the Basic. You can use them from more other supported programming languages and environments.

Re: [Solved, kind of] Macro to Toggle Sheet Protection

Posted: Fri Sep 29, 2017 9:03 am
by daveg7
Thank you, and I'll seriously consider your advice.

Köszönöm (just looked up the one word, and I know very little more than that about the languages we're discussing. ;)