protecting certain cells

  • Thread starter Thread starter pindu12
  • Start date Start date
P

pindu12

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
 
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?
Click to expand...

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

/Dann
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I count a tickbox in a spreadsheet? 1
Signature in a protected document 0
Excel Typed text appears in wrong cell 0
Can A Tickbox Backcolor Change & If So How Would It Be Done?? 2
How to filter rows data based on background color of individual cells 1
Cell shows the last typed text, no matter where it is typed 0
Excel Linking (I think) 17
dimensions (heights) of cell comments 1

Back
Top