View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] pindu12@hotmail.co.uk is offline
external usenet poster
 
Posts: 1
Default 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