Protecting data after entering

  • Thread starter Thread starter jimbo
  • Start date Start date
J

jimbo

I have three columns of data that need to be entered into one row per
day. Then I have some calculations on the same row, in the columns to
the right. What I would like to do is to protect the data from being
changed once it has been entered while still allowing the form to be
entered the next day. Then, the next day the data is entered, the
calcs calculated, and automatially protected. I don't want to rely on
a manaul process because so many different people will be entering.
 
Jimbo
This can be done with an event macro. An event macro is one that fires
automatically, but a specific event has to occur to trigger the macro. You
say that 3 columns are filled in by the user in a given row . What
constitutes the completion of that? Is it an entry in a specific (the
third?) column? If so, can it ALWAYS be assumed an entry into that column
completes the entries even though one or both of the other 2 columns are
blank? Or would you want the macro to check that all 3 columns are filled
and then, and only then, fire the macro?
You would start with all the cells unlocked. Then you would lock all the
cells into which entries have already been made. Then you would protect the
sheet. This will protect all the locked cells. When the macro fires, it
will unprotect the sheet, lock all the cells in that row, and protect the
sheet. Does this sound like what you want? HTH Otto
 
Back
Top