[Solved] Lock a sheet an part it with others

Discuss the spreadsheet application

[Solved] Lock a sheet an part it with others

Postby open11 » Tue Aug 07, 2018 2:31 pm

Å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 21 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
open11
 
Posts: 2
Joined: Tue Aug 07, 2018 9:03 am

Re: Lock a sheet an part it with others

Postby Zizi64 » Sun Aug 12, 2018 7:45 am

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; LO4.4.7, LO6.1.1 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.2 and AOO4.1.5
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.
User avatar
Zizi64
Volunteer
 
Posts: 7439
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Lock a sheet an part it with others

Postby open11 » Sun Aug 12, 2018 9:29 am

SOLVED
OpenOffice 4.1.5 on Windows 7 Ultimate
open11
 
Posts: 2
Joined: Tue Aug 07, 2018 9:03 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests