protecting certain cells
Hello there.
I would like to make a spreadsheet for the office to use, but it has
several requirments that i cannot seem to do.
i want the spreadsheet like this
Name | Password | Job | Tickbox | Comment
those are the column headings. I want everyone to be able to view the
spreadsheet, but only the named users can change their row. So i was
wondering is it possible to apply a small different code to each user,
so when typed correctly they can change their row?
The second requirement is that when the tickbox is not selected, the
comment cell is blocked (so nothing can be typed in)
Many thanks for any input
|