software

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 dataAre you sure you want to do this? One person could potentially overwrite
the whole thing.

quot;Pierrepanquot; gt; wrote in message oups.com...
gt;I have workbook in Excel 2000 with 30 worksheets. One for each
gt; employee.
gt; I want each employee to see only their worksheet and not the others.
gt; In other words when an employee opens the workbook, it would ask for
gt; their name and password. The employee would then have the ability to
gt; add data to his/her worksheet
gt; I as supervisor would see the whole workbook after all employees have
gt; entered their data
gt;
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.