Thread: Restricting access to a range of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
anandmr65 anandmr65 is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote