Protecting data after entering
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. |
Protecting data after 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 "jimbo" wrote in message ... 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. |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com