Forum Discussion
Need help with holiday scheduler
Hi everyone,
i'm currently working on adjusting below screenshoted table in which i have dropdown for every single day and name from which i can select reason for absence. One of the reason is HomeOffice attendance.
This sheet is protected so people cant just assign holiday to themselves.
I would like to have permission in this sheet for specific person to assign only specific reason. Lets say, Name1 can assign only HO from dropdown to him/herself and nothing else from dropdown.
Does anybody have any idea how to do this? Is it even possible?
Thank you in advance for all your ideas.
I would say this is possible to do with some VBA code in your workbook as well as with auxiliary data establishing these rules.
Don't know if you are familiar with VBA, but these are my concerns:
- It would require a worksheet change subroutine, which would entail triggering certain amount of calculations/readings and, depending on the size of the document, could affect its performance.
- Any solution wouldn't be foolproof. Anyone determined to circumvent it, could do it.
to follow on Martin_Angosto reply, additional concern with VBA is that it is not supported in the web version and since you included the 'Excel for web' tag that might be a non-starter. However, it might be possible to create this or similar functionality using Scripts, but not sure how that would work and if that would work for you. For example I could see a button and based on the user logged in it could do certain operations but the structure and flow would likely have to change and not be the 'simple' drop down you envisioned.
