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 HomeO...
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.