OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Protect spreadsheet on certain date

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
danielg74
Newbie
Newbie


Joined: 11 Jan 2012
Posts: 3

PostPosted: Thu Jan 12, 2012 1:01 pm    Post subject: Protect spreadsheet on certain date Reply with quote

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.
Back to top
View user's profile Send private message Yahoo Messenger
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Thu Jan 12, 2012 1:32 pm    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
danielg74
Newbie
Newbie


Joined: 11 Jan 2012
Posts: 3

PostPosted: Sat Jan 14, 2012 11:40 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Yahoo Messenger
newbee391
General User
General User


Joined: 04 Jan 2012
Posts: 17
Location: New York, USA

PostPosted: Sat Jan 14, 2012 1:21 pm    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
danielg74
Newbie
Newbie


Joined: 11 Jan 2012
Posts: 3

PostPosted: Sun Jan 15, 2012 1:28 am    Post subject: Reply with quote

My post is how I can do to automatically protect a sheet at a certain time (end of the day, midnight) for changes.
Back to top
View user's profile Send private message Yahoo Messenger
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Sun Jan 15, 2012 3:01 am    Post subject: Reply with quote

Hi,
Quote:
My post is how I can do to automatically protect a sheet at a certain time (end of the day, midnight) for changes.
Yes we know and the answer was that this is not possible.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group