Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multi-level passwords
Is it possible to create multiple passwords allowing different users to be
able to wiev (an write in) different columns in the same spredsheet? Also, is it possible to have an automatic updating process when different users change items in the spredsheet? |
#2
|
|||
|
|||
Dear Sir I am using Excel Xp in a Windows Xp Pro System: Try this: Tools Protection Allow Users to Edit Ranges Once you do that a window appears that let you protect different ranges with different passwords and also assign NTFS permissions. For the options to take effect the sheet must be password protected. Yes, it is possible to have an automatic updating process user based, it would require some VBA programming. If still needs help setting the passwords please let me know I can send you a short video .wmv format so you can see the steps to follow. Regards Juan Carlos -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=376990 |
#3
|
|||
|
|||
That password is internal to excel and can be anything that the developer
wants. It doesn't have anything to do with NTFS. cscorp wrote: Dear Sir I am using Excel Xp in a Windows Xp Pro System: Try this: Tools Protection Allow Users to Edit Ranges Once you do that a window appears that let you protect different ranges with different passwords and also assign NTFS permissions. For the options to take effect the sheet must be password protected. Yes, it is possible to have an automatic updating process user based, it would require some VBA programming. If still needs help setting the passwords please let me know I can send you a short video .wmv format so you can see the steps to follow. Regards Juan Carlos -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=376990 -- Dave Peterson |
#4
|
|||
|
|||
Hi Carlos and thank you very much. However this doesn't solve my problem with different users able to view different part of the sheet. -- Todor ------------------------------------------------------------------------ Todor's Profile: http://www.excelforum.com/member.php...o&userid=24095 View this thread: http://www.excelforum.com/showthread...hreadid=376990 |
#5
|
|||
|
|||
Hi Dave thank you for the reply. Is there any way to make different users
wiev different parts of the spredsheet or to view certain spredsheets in a single workbook? "Dave Peterson" wrote: That password is internal to excel and can be anything that the developer wants. It doesn't have anything to do with NTFS. cscorp wrote: Dear Sir I am using Excel Xp in a Windows Xp Pro System: Try this: Tools Protection Allow Users to Edit Ranges Once you do that a window appears that let you protect different ranges with different passwords and also assign NTFS permissions. For the options to take effect the sheet must be password protected. Yes, it is possible to have an automatic updating process user based, it would require some VBA programming. If still needs help setting the passwords please let me know I can send you a short video .wmv format so you can see the steps to follow. Regards Juan Carlos -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=376990 -- Dave Peterson |
#6
|
|||
|
|||
Nothing that would be secure. Excel's worksheet protection is easily broken.
Todor wrote: Hi Dave thank you for the reply. Is there any way to make different users wiev different parts of the spredsheet or to view certain spredsheets in a single workbook? "Dave Peterson" wrote: That password is internal to excel and can be anything that the developer wants. It doesn't have anything to do with NTFS. cscorp wrote: Dear Sir I am using Excel Xp in a Windows Xp Pro System: Try this: Tools Protection Allow Users to Edit Ranges Once you do that a window appears that let you protect different ranges with different passwords and also assign NTFS permissions. For the options to take effect the sheet must be password protected. Yes, it is possible to have an automatic updating process user based, it would require some VBA programming. If still needs help setting the passwords please let me know I can send you a short video .wmv format so you can see the steps to follow. Regards Juan Carlos -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=376990 -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
Hi Dave, Please go to Tools Protection Allow Users to Edit ranges... Once there add a new range and click permissions... try to enter a user that does not have an account in the system and let me know what you think. It is used to allow certain users to edit without having to enter the password set. I am using XP PRO regards Juan Carlos +-------------------------------------------------------------------+ |Filename: Permissions .jpg | |Download: http://www.excelforum.com/attachment.php?postid=3463 | +-------------------------------------------------------------------+ -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=376990 |
#8
|
|||
|
|||
But you don't need to use permissions button to protect the ranges.
It seems it's kind of the opposite of what the OP wanted--but I see your point. It could be a useful technique to allow changes. (I don't have access to multiple users/different groups.) cscorp wrote: Hi Dave, Please go to Tools Protection Allow Users to Edit ranges... Once there add a new range and click permissions... try to enter a user that does not have an account in the system and let me know what you think. It is used to allow certain users to edit without having to enter the password set. I am using XP PRO regards Juan Carlos +-------------------------------------------------------------------+ |Filename: Permissions .jpg | |Download: http://www.excelforum.com/attachment.php?postid=3463 | +-------------------------------------------------------------------+ -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=376990 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function that gives Group level? | Excel Worksheet Functions | |||
HELP!? Passwords are driving me crazy. | Excel Worksheet Functions | |||
How can I increas undo level in Microsoft EXCEL ? | Excel Discussion (Misc queries) | |||
How can I increas undo level in Microsoft EXCEL ? | Excel Discussion (Misc queries) | |||
How can I increas undo level in Microsoft EXCEL ? | New Users to Excel |