tomski
12-10-2018, 03:22 AM
Hi,
I'm struggling with the following:
I have a workbook with different worksheets containing people's working hours and working schedules.
There are two sheets that are allways visible: Agenda and Tasks
These sheets should be allways visible for every user, but they should only be read-only, except for the administrator of the file.
Then there are five more sheets, one per employee containing the working hours of that employee. The emloyee who logs in should only be able to see the sheets Agenda, Tasks and his individual sheet, all in read only modus.
The administrator that logs in should be able to see everything and needs write access to all sheets.
I don't know how to accomplish this, I even don't know if it's possible at all…
What I've got till now:
* Employees can log in to the workbook and can see 3 sheets, but they have write access and thats not as it should be.
* The Administrator can't login :-)
Can anyone help me out?
Thanks!
Tommy
I'm struggling with the following:
I have a workbook with different worksheets containing people's working hours and working schedules.
There are two sheets that are allways visible: Agenda and Tasks
These sheets should be allways visible for every user, but they should only be read-only, except for the administrator of the file.
Then there are five more sheets, one per employee containing the working hours of that employee. The emloyee who logs in should only be able to see the sheets Agenda, Tasks and his individual sheet, all in read only modus.
The administrator that logs in should be able to see everything and needs write access to all sheets.
I don't know how to accomplish this, I even don't know if it's possible at all…
What I've got till now:
* Employees can log in to the workbook and can see 3 sheets, but they have write access and thats not as it should be.
* The Administrator can't login :-)
Can anyone help me out?
Thanks!
Tommy