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?

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

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

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

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

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

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

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