Greetings,

I am using Excel 2007. I have a workbook with over 50 sheets in it. I want to see if I could make all of the worksheets hidden from view unless there is a password that will be entered, in order to view the corresponsing sheets. I also need to be able to have the sheets hidden again once the file is saved ( or on close ). Not everyone will have access to the same sheets. Only one person ( aside from myself ) will have access to all of the sheets.

Is there a way to assign individual passwords for each separate user so that I can have the user enter their password to reveal the sheet(s) that they will be working on?

Thanks!