I have had a look around various forums but due to my elementary knowledge of excel and VBA in particular I have not been able to piece together a working solution to this issue so PLEASE help of you can. If you could answer step-by-step that would be great because I basically have no working knowledge of VBA.

I have a workbook with about 50 sheets. I need individuals to be able to access to workbook and only see certain sheets - about 5 to 10 sheets each.

Weather using Usernames or other passwords I have not been able to make a working solution to this, please help.

Thanks,
icka