Hello,
Could Holidays be shown next to Schedule sheet calendar days from the Admin & Settings sheet?
I put shapes next to the days in January for the Holidays referencing the dates from the Admin & Settings sheet. Maybe this could be done with VBA similar to the way the appointments are posted (see the month of May for some appointment examples).
Thank you for your help
Last edited by billy60; 03-23-2023 at 03:17 AM.
Is this a VBA question? I've moved it for you to the VBA section and marked it UNSOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you very much.
Last edited by billy60; 03-26-2023 at 07:12 AM.
Maybe this isn't possible to do or I have not properly stated what I wanted to achieve.
Thank you for trying.
Button "Mark Holidays" given in the sheet. Holidays are marked in the cell.
When the month is changed holidays are not removed. Change the code in those macros to erase the holidays when month is changed.
Code:
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Could the results be attached to a shape that can be put next to the calendar days?
Last edited by billy60; 03-26-2023 at 09:37 AM.
A solution was achieved with formulas. Thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks