[SteveMat]

I have a workbook with about 80 sheets in it. I need to give 80 people access to their respective worksheet without them being able to view the other data. I was thinking of creating an opening page that checks for a username and password and then redirects that users to his/her and only his/her worksheet. I need to update the data in the workbook on a monthly basis and all kind of formulas need to be performed so there is not much other way than doing this in Excel.
can I write something in Visual Basic that allows me to create this? I already found an article on UserForms on the Microsoft Support site that will get me started I guess, but then I still need all the underlying codes?
I need this for work so my time on research and creation is rather limited
thanks a zillion in advance!!!!

[bomb #21]

"can I write something in Visual Basic that allows me to create this?"

Absolutely. But it'll be as secure as a wet paper bag.

"80 people access to their respective worksheet"

How are you currently doing that? One file on a server, or 80 emails? If the latter, a routine to mail each sheet as a separate (one sheet) file to each of the 80 should be doable.

(welcome to the board )

[SteveMat]

Thanks a lot for the Welcome Bomb#21 !
Well for the moment there is nothing in place yet. Thing is that I need to send this list every month again, only the data changes (of course). And probably there are more of these lists coming. I was thinking of posting this on our Sharepoint site so that it would be really easy to update and maintain and at the same time is of no burden on the email system.
Security is not so much an issue as is discretion... I guess that anyone a bit knowledgeable will find a way to consult a colleagues data, but in fact that is not really a point.
I found already some scripts on the net but to actually build the thing still seems a bit difficult.
Or is there a completely different way of tackling this? I'm not stuck on this idea... it's simply the only solution I came up with

[bomb #21]

"Thanks a lot for the Welcome Bomb#21 !"

I'm not sure you mean that.

I'm just ... "obliged" to stress that as long as security is no issue, it's a simple as:

Sub test()
P_Word = Application.InputBox("Who are you?")
On Error Resume Next
Sheets(P_Word).Visible = True
Sheets(P_Word).Select
End Sub

, attached to a button on the "dashboard" sheet. HTH

[SteveMat]

woow... that's simple indeed! and this hides then the other pages in the workbook that the one person is not allowed to see? I'll go ahead and start some test workbook on this. Thanks a lot!!!

[bomb #21]

No, you start with only the dashboard sheet visible. The sheet with the name that matches the input (if one does) then becomes visible.

[SteveMat]

thanks a zillion! I'll give it a try and then mark this thread as solved.
Great!! saves me tons of work and research I can now use for better purposes !!!

[bomb #21]

Zero idea how Sharepoint works. If someone opens it, unhides a sheet, saves it, closes it then ... A N Other will see what was left. (?)

Google Workbook BeforeClose event, then tinker with:

For Each Sheet In ActiveWorkbook.Sheets
If Sheet.Name <> "Dashboard" Then
Sheet.Visible = False
End If
Next Sheet

(save wb -- close wb).

[SteveMat]

ok..I'll get to work with this info already and let you know.... thanks!