Passwords

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,

its called a macro. I managed to create on where by depending on what password a person type depended on which sheets they where able to see and access. is this what you are looking for. what you can also do is assign a default password for each one of them and then ask them to enter in their own password to remember.


if this is what you are looking for let me know i can help you out

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
"Manos" <[email protected]> wrote in message
news:[email protected]...
| 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,