Hello,
On the Admin & Settings sheet there are color code assignments for appointment status. I think it would be more appropriate to have these on the Schedule sheet so you can see the status colors there instead. When I tried to move them it messes up the code somewhere when trying to refresh.
Can someone please see how to move these and keep the coding working properly?
Thank you for help
1. Move F7:G15 to Schedule sheet cells D23:E31
2. Formulas -> Name Manager -> name Status -> in Refers to:
change to
(change semicolon ";" to comma "," if needed)
Please Login or Register to view this content.
3. In Sub Sched_Refresh
change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you very much hungt. Is it possible to reverse the colors and status columns so the colors are in column D instead and the status is in column E of the Schedule sheet?
I figured it out by moving the cells and changing in code from "E" to "D" column.
Thanks very much again!
Last edited by AlexDog; 06-03-2025 at 08:28 AM.
1. Formulas -> Name Manager -> name Status -> in Refers to:
change to
(change semicolon ";" to comma "," if needed)Please Login or Register to view this content.
2. In Sub Sched_Refresh
change
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks