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

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.

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

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