Hi, I have searched around the various forums and can not find anything to help delivery what I need.

I have a workbook with 10 worksheets. I would like to hide some of the spreadsheets based on which login is used. I only require 2 options which will be:

Login as "Finance" and all worksheets are viewed
Login as "Sales" and only 5 worksheets can be seen.

Can anyone help.

Thanks