I have a spreadsheet that is a To Do list. Is there a simple way with VBA to send an alert to the desktop when tasks are overdue, assuming that the spreadsheet starts with Windows and is minimized in the taskbar?
(To clarify, my question is about sending information to the desktop with VBA. It's not a problem to figure out if there are overdue tasks.)
Some possibilities might be to change the color of the icon in the taskbar depending on the status of the tasks, or to have a red graphic appear in the taskbar or elsewhere when there are overdue tasks, etc.
Thanks.
(To clarify, my question is about sending information to the desktop with VBA. It's not a problem to figure out if there are overdue tasks.)
Some possibilities might be to change the color of the icon in the taskbar depending on the status of the tasks, or to have a red graphic appear in the taskbar or elsewhere when there are overdue tasks, etc.
Thanks.