Question:
I have a multi-worksheet Excel 97 file that I need to share on a
network with others. However, each of the others should only see his
or her own worksheet, and not see the others. And they need to be
able to share the file - edit it at the same time - since everything
around here is done under a dealine, of course.
There is extensive linking between worksheets, so I can't distribute
the worksheets to users, they need to be edited in place.
Answer:
I would redesign what you are doing to individual sheets. Any approach you
use only takes a few minutes to find a password cracker and get at the
information.
My users aren't sophisticated enough to use password crackers. Is
there any way of doing what I want, even though a password cracker
could crack it?
What you could do is hide *all* worksheets and give each user a password.
When the spreadsheet is opened have a pop-up dialog box asking the user to
enter their password and unhide the appropriate sheet.
Is it not possible for you to hold the master workbook and for each user to
hold their own workbook?
Then link each users book to the relevant sheet within the master?
