Protect Execl data for different users.

Giganews Newsgroups
Subject: Protect Execl data for different users.
Posted by:  Saurabh
Date: Tue, 30 May 2006

Hello,
Is it possible to protect different areas in an Excel sheet for different
users based on some password?

ie: I want to setup an Excel file over a network location and define some
specific rows and columns values to be updated only by specific users. For
example, first tow rows and columns can only be updated by User1 and not by
others and so on. So, when they try to update their respective sections they
should be asked for some sort of password and then only be allowed to update
their assigned cell's information.

Is it possible to achieve something like this?

Thank You,
Saurabh Khanna.

Replies