>>>Good day
>>>I have a situation where a number of people have to enter data into an .xls one after another. i'd like to ensure that each one could enter data only in a region of cells assigned to that particular user.
>>>Is it possible to divide a worksheet into areas accessible to different users.
>>>I was thinking in terms of different passwords but there could be only one password.
>>>Is there anything i could do?
>>>
>>>Regards
>>>Kamil
>>
>>Split up the spreadsheet into sections specifically for each user, or write a multiuser app (not in Excel) for data entry.
>
>How do i ensure that a user enters info only in his section?
Physically break up the spreadsheet into seperate spreadsheets - one for each type of user.
I realize that is not very practical, and there may be some better way to do it with Excel.
I'd much rather write the multiuser app than try to accomplish this in Excel.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________