[Solved] Lock a sheet an part it with others
[Solved] Lock a sheet an part it with others
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]
Reason: Tagged [Solved] [robleyd, Moderator]
OpenOffice 4.1.5 on Windows 7 Ultimate
Re: Lock a sheet an part it with others
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)
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.
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.