Protect Execl data for different users.

G

Guest

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.
 
R

raypayette

Given that it is possible to hide columns or rows with a password, it
would be possible to write a macro that would unhide different rows and
columns with different passwords.
As it is commonly known however, this protection can easily be
unlocked.

HTH
Ray
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PROTECTION FOR DIFFERENT COLUMN OF A WORKSHEET 1
VBA - retrieve data on last create named range from previous inserted named range 0
Protect Worksheet to share with older versions of excel 2
Protect 2
Allowing different users access to different worksheets 1
Need to lock 2 rows in a sheet 1
Automatic populate Sheet2 with data from Sheet1 based on criteria. 2
Protecting cells for different users 2

Top