ZacCerrato
Board Regular
- Joined
- Jun 2, 2010
- Messages
- 76
I don't know much about the protection of cells in worksheets. I wonder if it is possible to allow a value to be entered into a cell, but to disallow users from deleting or changing that information?
The reason I am asking is that I have created a simple database to keep track of experiments done on objects. I have a main sheet where I have a unique, numeric ID assigned to each object. Each object has it's own row of basic, descriptive data on this main sheet. On multiple other sheets, I have this descriptive data of each object repeated by automatically generating from my first, main sheet using =vlookups. This way, we are not having to repeatedly type this information into our spreadsheets.
As I run experiments on these objects I am entering findings beside these numeric IDs (I have the descriptive data hidden). However, I realized that now there is no fail-safe/secure way to keep this data secure on other sheets. If someone were to accidentally delete or change the unique, numeric ID - all information identifying the object which was tested/experimented-on would be lost.
I want to both secure information that has been entered, but still allow for new entries to be entered easily.
Is there a simple way to allow a value to be entered into a cell, but to disallow users from deleting or changing that information once entered? Is there some clever sheet protection or cell protection function that I can use?
Thanks in advance for any responses.
The reason I am asking is that I have created a simple database to keep track of experiments done on objects. I have a main sheet where I have a unique, numeric ID assigned to each object. Each object has it's own row of basic, descriptive data on this main sheet. On multiple other sheets, I have this descriptive data of each object repeated by automatically generating from my first, main sheet using =vlookups. This way, we are not having to repeatedly type this information into our spreadsheets.
As I run experiments on these objects I am entering findings beside these numeric IDs (I have the descriptive data hidden). However, I realized that now there is no fail-safe/secure way to keep this data secure on other sheets. If someone were to accidentally delete or change the unique, numeric ID - all information identifying the object which was tested/experimented-on would be lost.
I want to both secure information that has been entered, but still allow for new entries to be entered easily.
Is there a simple way to allow a value to be entered into a cell, but to disallow users from deleting or changing that information once entered? Is there some clever sheet protection or cell protection function that I can use?
Thanks in advance for any responses.