Protect spreadsheet on certain date

[danielg74]

At work we have to fill up a form, every day of the week (Mo to Su, one spreadsheet for each day). During the week people start to change the data from the past days and at the end of the week the file is a mes. If somebody can help me to create some formulas after the day is ending to protect the spreadsheet for any changes. In this way I can make a file with seven spreadsheets at the start of every week.

[mgroenescheij]

Hi,

That is not possible in Calc but if you use Base as a front end to an external database.
Create a Form in Calc that connects to the database.
In this form you can allow users to add records, but limited the changes records based on a data filter.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[danielg74]

Thank you Martin for the time spending reading my post.
I have this spreadsheets (for each day of the week) in Calc only. Is a spreadsheet were each shift manager is writing, orders, reservation etc. I see in excel that is possible to do something similar working with macros and VBA. I want to now if somebody can help me to do this in Calc.

[newbee391]

1. Protection of a Sheet
To write-protect all of the cells of a sheet, you have to do the
following:
* Select Tools-Protect Document from the Menu Bar,
* if you choose Sheet..., only your current sheet will be
protected from writing,
* If you choose Document..., your whole document (workbook) will
be protected.
You are not obliged to enter a password, you can simply click on
the OK button to close the dialog window without typing anything.
However, if you choose a password, it will be requested every time
you wish to modify the cells or the sheet.
To eliminate the protection, choose Tools-Protect Document again
and deselect the Sheet... or Document... option, eventually typing
the password you have set, when requested.
2. Protection of a cell or of a cells group inside a
document
* Select a range or all the cells of your sheet, with CTRL+A or
by clicking the gray rectangle between the rows and columns
headings,
* In the Format menu, select Cell and from the dialog window
that will appear, switch to the Cell Protection tab,
* Deselect the check box called Protected (the cells are
protected by default),
* Then select the cells you wish to protect,
* From the Menu bar choose Tools-Protection-Sheet...,
* By choosing Format -Cell and by checking the Protected check
box again, it will protect the selected cells.

Hope that this will help

_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[danielg74]

My post is how I can do to automatically protect a sheet at a certain time (end of the day, midnight) for changes.

[mgroenescheij]

Hi,