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
|