| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricting access to a range of cells
Hi, I have a file in shared folder that will be used by about 4 or 5 people. Each one will be updating a particular range everyday.For eg. User A updates from A1 to A100, User B updates the range B1 to B100 and so on. To prevent any problems, I want to restirct the user A to access only the range A1 to A100, and user B to access B1 to B100. Can this be achieved in excel? I though of locking the cells and giving the password, but all users will have only one password. Please help. Thanks & rEgards Anand -- anandmr65 ------------------------------------------------------------------------ anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728 View this thread: http://www.excelforum.com/showthread...hreadid=565091 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link a range of cells | Excel Worksheet Functions | |||
| Determine whether a value is in a range of cells | Excel Discussion (Misc queries) | |||
| how to format only specific characters or numbers within each cellwithin a range of cells | Excel Discussion (Misc queries) | |||
| Count occurances in range of cells | Excel Worksheet Functions | |||
| Select Range of Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
