Open worksheet

  • Thread starter Thread starter Bert
  • Start date Start date
B

Bert

Good afternoon,

I made a workmap with different sheets. I want to allow 4 people to openthe
workmap. But I also would like to give them a different password. Is that
posible?
I would like after the try to open the map a kind of popup screen where they
give in or chose their name and than give their password, after that's is ok
they can work in the map.

Thanks a lot

Bert
 
A workbook can only have one password.

You might create separate workbooks for each person (each
with its own password), then collect their data in
another workbook that has separate sheets for each
person. The sheets would references the cells in the
individuals' workbook.
 
You have me confused here. What is the advantage of different passwords? Do
you want them to see different sheets in the workbook? Or do you log access?

Geoff
 
Hello GB,
I guess didnt make myself clear enough, I would like to log the 4 users, but
i do not have thew slightest idea if it is possible and if it can be done in
Excel.

Bert
 
Bert said:
Hello GB,
I guess didnt make myself clear enough, I would like to log the 4 users, but
i do not have thew slightest idea if it is possible and if it can be done in
Excel.

Bert
Click to expand...


OK - this can all be done in Excel, using VBA. I am not sure where there is
sample code lying around, but this must have been done before.

You save the workbook with all the sheets hidden.

Then when your user opens the workbook you use the workbook_open event to
trigger an input box into which the user can put his user name/password.
Then check that against values stored in your VBA code. If okay, append the
time/date and user name to your log file. Then unhide the sheets in the
workbook.

You need to use the beforesave event to re-hide the worksheets.

HTH

Geoff
 
oops, now it is getting very diificult as I don't know anything about VBA.
So I guess it cannot be done by me. But thanks anyway.

Bert
 
Back
Top