Passwords

[Manos]

Dear all

i am using excel XP edition
i have a file in the public folder for 50 users. My file used only by 10
people

there is a possibility to lock each sheet of the same file with different
password in order each user to have access to his own sheet.
If there is such a possibility can you please provide the way of doing that?

Regards,

 

[Jim Rech]

There is no feature in Excel that requires a password to view particular
worksheets in a workbook. The best you could do is some kind of macro based
system for unhiding sheets (sorry I don't have an example). But even with
such a system a knowledgeable user would be able to get to the other sheets
if he really wanted to.

--
Jim Rech
Excel MVP
| Dear all
|
| i am using excel XP edition
| i have a file in the public folder for 50 users. My file used only by 10
| people
|
| there is a possibility to lock each sheet of the same file with different
| password in order each user to have access to his own sheet.
| If there is such a possibility can you please provide the way of doing
that?
|
| Regards,