Hi

I have a workbook with 9 worksheets in it. When the workbook is opened by a user, I need them to have to fill in a password immediately be able to view specific sheets. I have 4 types of User.

1. There are Sales Representatives (Team 1) which need to be able to view sheets 1, 2 and 5.
2. There are Sales Representatives (Team 2) which need to be able to view sheets 3, 6 and 7.
3. There are Managers which need to be able to view sheets 8 and 9.
4. There is a Sales Director who needs to be able to view all the sheets.

I have found a few answers on the forum which get me half way there but my VBA is not great!

Please can anyone help with a solution?

Many thanks for any help

Best Wishes

Kev