Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Execl data for different users.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Execl data for different users.
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 -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=546621 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions |