Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protecting cells | Excel Discussion (Misc queries) | |||
Protecting locked cells | Excel Discussion (Misc queries) | |||
Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Protecting certain cells | Charts and Charting in Excel |