I use a work book to keep a record of each staff members holiday records.
Work book comprises of a master sheet which collates entitlement and remaining hours for each staff member (linked from their individual worksheet)
Each staff members records are recorded on a desperate worksheet named as a number. 1, 2, 3 etc
The workbook is protected to read only for staff, but all staff members can view each others records.
What I want to achieve is to set up individual passwords for each staff member so that when opening the workbook they can only see their worksheet. But, also set so that I can open all worksheets with only entering one password and not having to use staff members individual passwords to update their records.
Hopefully not a mamouth task.