One Workbook - Multiple Sheets with individual passwords

[JGARDNER-AIT]

Hello - Is there and option to select to have multiple worksheets with individual sheet passwords. When the sheet is locked, can the data not be visible?

Each sheet is a pivot table for the main sheet. The individual sheets are by team leaders and thier employees to view employee data. Other team leaders are not allowed to view the other leaders employee data. Therefore i thought of keeping it in one workbook and protecting each leaders sheet with a password, but the sheet cant be visible.

Anyones help would be greatly appreciated.

Im using Excel 2003.

 

[Jaafar Tribak]

Hello - Is there and option to select to have multiple worksheets with individual sheet passwords. When the sheet is locked, can the data not be visible?

Each sheet is a pivot table for the main sheet. The individual sheets are by team leaders and thier employees to view employee data. Other team leaders are not allowed to view the other leaders employee data. Therefore i thought of keeping it in one workbook and protecting each leaders sheet with a password, but the sheet cant be visible.

Anyones help would be greatly appreciated.

Im using Excel 2003.

This can surely be achieved with VBA code but if the user disabels Macros then it becomes pointless.

Better to have different password protected workbooks for different users .