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

protecting certain cells
 

wrote in message
oups.com...
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?

Is your LAN on a Active Directory/Domain or is there any other centrally
managed user validation?

/Dann

protecting certain cells
 

Maby u can use this sheet or som of it
i dont no what Tick-box is

http://pmexcelent.dk/Emploi.xls