Thank you very much.
i have to put up with Excel (instead of an app), its a part of a workflow in my company.
All the best, William.
>>>>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.
A moment of silence is our cosmic reset button.