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