[Solved] Lock a sheet an part it with others

Discuss the spreadsheet application
Post Reply
open11
Posts: 2
Joined: Tue Aug 07, 2018 9:03 am

[Solved] Lock a sheet an part it with others

Post by open11 »

Åtgärdslista .ods 111 Mall.ods
https://forum.openoffice.org/en/forum/download/file.php?mode=view&id=35686&sid=d333fd5eaea867c852e5788ce75de6c6
(10.43 KiB) Downloaded 68 times
HI

OPEN OFFICE CALC

I have made a sheet that I have attached. This sheet I want to lock so that I need a password to change it.

I also want to be able to send the sheet to others so that they ca fill in information in the sheet. I therefore want to share it.
I hawe tried so hard to get it work, but not succeded.
You perhaps can help me.

Regards
Staffan
Sweden
Last edited by robleyd on Sun Aug 12, 2018 10:27 am, edited 1 time in total.
Reason: Tagged [Solved] [robleyd, Moderator]
OpenOffice 4.1.5 on Windows 7 Ultimate
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Lock a sheet an part it with others

Post by Zizi64 »

If I understood exactly your problem:

Do you want to protect some cells, and do you want to leave some cells unprotected?

Just use different cell styles with different protection settings. Then switch on the sheet protection function (with or witout password). From the menu: Tools - Protect document - Sheet
Then you must save the document (with or without password)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
open11
Posts: 2
Joined: Tue Aug 07, 2018 9:03 am

Re: Lock a sheet an part it with others

Post by open11 »

SOLVED
OpenOffice 4.1.5 on Windows 7 Ultimate
Post Reply