Hide and PW protect multiple worksheets
 

I have workbook in Excel 2000 with 30 worksheets. One for each
employee.
I want each employee to see only their worksheet and not the others.
In other words when an employee opens the workbook, it would ask for
their name and password. The employee would then have the ability to
add data to his/her worksheet
I as supervisor would see the whole workbook after all employees have
entered their data

Hide and PW protect multiple worksheets
 

Are you sure you want to do this? One person could potentially overwrite
the whole thing.

"Pierrepan" wrote in message
oups.com...
I have workbook in Excel 2000 with 30 worksheets. One for each
employee.
I want each employee to see only their worksheet and not the others.
In other words when an employee opens the workbook, it would ask for
their name and password. The employee would then have the ability to
add data to his/her worksheet
I as supervisor would see the whole workbook after all employees have
entered their data

Hide and PW protect multiple worksheets
 

Good point. Maybe this is not the best idea, I've had. Can you tell me
if it is possible to restrict the ability only to the worksheet
assigned to the employee? Thanks for your help and input.