I have a workbook which is used to record absences, annual leave etc.
One of the worksheets in the workbook displays details of the percentage of staff who are in planned to be in work on each day of the month, and the minimum percentage of staff we can afford to have in. The worksheet is named Staff Availability. It is populated based on the other sheets in the workbook which are maintained by 1 person only.
This allows us to gauge whether or not we can accept requests for time off.
This workbook is in a shared access folder.
Is there any way I can share a shortcut to all staff which only shows them the Staff Availability worksheet, and which is always protected (to prevent people making changes to guarantee their own time off), but which updates automatically?
One of the worksheets in the workbook displays details of the percentage of staff who are in planned to be in work on each day of the month, and the minimum percentage of staff we can afford to have in. The worksheet is named Staff Availability. It is populated based on the other sheets in the workbook which are maintained by 1 person only.
This allows us to gauge whether or not we can accept requests for time off.
This workbook is in a shared access folder.
Is there any way I can share a shortcut to all staff which only shows them the Staff Availability worksheet, and which is always protected (to prevent people making changes to guarantee their own time off), but which updates automatically?
