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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricting access to a range of cells
It depends on the version of xl you are using. I know xl2002 have this
feature. "anandmr65" wrote in message ... 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 |
Reply |
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) |