Applying individual protection to multiple sheets for different users

I have a worksheet that contains a number of sheets. I would like to send this to a number of users. But each user must only be able to access there part of this worksheet.
So can I protect each worksheet so that its contents are hidden to all users until a correct password is entered.
Or even better can it recognise the users ID and give them the access they require, and hide everything else.

Look forward to hearing from you all.

Many thanks,
Leighton.

 

[SkipVought]

Hi,

You set the Visible property for each sheet that you want to be hidden to xlSheetVeryHidden. This can only be changed via VB or in the VB Editor.

You get the user's password and then assign the xlSheetVisible value to the appropriate worksheet Visible property that they're permitted to access in this workbook.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[KenWright]

And you make sure to protect the code such that they don't just nip in and find the other passwords

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------