Is there a way to have Excel automatically notify me when a date is approaching or has passed?
R rouennais Feb 1, 2008 #1 Is there a way to have Excel automatically notify me when a date is approaching or has passed?
B Bob I Feb 1, 2008 #2 You would have to compare "Now()" against the date in question and open the file that contained it occasionally.
You would have to compare "Now()" against the date in question and open the file that contained it occasionally.
S Stan Brown Feb 2, 2008 #3 Fri, 1 Feb 2008 09:57:00 -0800 from rouennais Is there a way to have Excel automatically notify me when a date is approaching or has passed? Click to expand... IMHO Excel is the wrong tool for that job. You've already got Task Scheduler in Windows; schedule it to pop up a reminder on the appropriate date.
Fri, 1 Feb 2008 09:57:00 -0800 from rouennais Is there a way to have Excel automatically notify me when a date is approaching or has passed? Click to expand... IMHO Excel is the wrong tool for that job. You've already got Task Scheduler in Windows; schedule it to pop up a reminder on the appropriate date.